BMC AMI Data vs. Sequel Pro

According to my experience BMC AMI data has been one of the best report creating software for our business as it's integrates all the business system with a single dashboard and make sure that we are able to understand our products and customers better. It also helps in focusing which part of our business is strong and which need more planning

Incentivized

• Super easy for quick development and investigation
• The interface of exporting tables to SQL can be made better, it's not easy to manually check
• Not suitable for designing your DB
• Connections over SSH to vagrant and Docker hosted DBs
• Auto suggestion can be better

Incentivized

• IMS backup and recovery resolution improve the efficiency
• Supports very precise recovery, which lowers risk and minimizes data loss.
• IMS Log analyzer provides information we need

Incentivized

• Editing existing data. Editing record contents is trivial in Sequel Pro, while not nearly as easy in MySQL Workbench or phpMyAdmin.
• Deleting data - even simpler than editing data.
• Inserting new data - using "Duplicate row" then making needed changes is very simple.

Incentivized

• In Change Manager, IDAA objects can't be analyzed. This is a big issue if you have Accelerated Tables in your shop.
• Not able to find how runa Accelerated tasks in batch, especially long time loading
• .

Incentivized

• Improving the way we create new connections to remote databases
• I couldn't find any way to configure my local server (MySQL), so I need to make changes on server outside the application. I know that there are other tools that integrate it, so you don’t have to leave the workflow
• It could have a feature to integrate our databases or connections (favorites) with other devices, like using Google Drive or Dropbox. It would be really useful!

Incentivized

With the BMC AMI Data, we can manage, access, and analyze our mainframe data across IT teams. It helps us to solve the data accessibility and visibility challenge. We can search for data, ensure its quality, and share it securely with the development team. We can easily track, audit, and optimize our data. Saves time. Faster decision-making. Reduce downtime risks. Improve compliance.

Incentivized

It is easy to use, but the design could use updating as it's very dated.

Incentivized

It's open-source and very convenient to work with. I can easily import any database I want using a data dump and runt the queries on them to derive the data insights on the data. I might want to use Excel to visualize that, that might be one of the disadvantages.

Incentivized

BMC AMI uses AI and DataOps to automate routine maintenance, reorganization, and backup, acting as a "self-managing" system. DBArtisan is a more hands-on administration tool tailored for DBA daily tasks like schema management, SQL tuning, and security. BMC AMI Data is tailored for enterprises that rely heavily on the mainframe for high-volume transactions. DBArtisan is ideal for general DBAs managing a mixed portfolio of databases.

Incentivized

MySQL workbench is good to work with MySQL databases, but Sequel Pro gives us the ability to work with any SQL databases. It's open-source, lightweight and solves the problem that I am required to solve to run the DDL and DML queries.

Incentivized

• Number of ver less error in data leads to a great profit
• Easy maintenance helps to hasslefree uses
• Gives great projections and made our company good profits

Incentivized

• Unreliability has lead to wasted time and frustration among staff.
• The ease of testing database changes and modifying test data WHEN IT WORKS theoretically makes testing quick and easy but in reality, this is far outweighed by the wasted time and frustration involved with it not being reliable.
• The ease of seeing the relations between tables is very nice and saves time when trying to see how unfamiliar tables are connected.

Incentivized