BMC AMI Data vs. DbVisualizer vs. DataGrip

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

DbVis is our tool of choice when we need to work with a wide variety of Db vendors and versions. It allows us to replace several proprietary tools for accessing and, in part, managing database systems. It gives our customers and us a single base to work on databases. No need for us or them to install, learn, and pay for multiple solutions. If one would, for example, use ONLY one dbms, e.g., PostgreSQL, then DBVis could be a bit of an overkill.

You will like DataGrip; it is the best software to channel and influence data systems and efficiently. It will help you be more efficient and productive in exporting computer data; it is very effective. There are no errors, and you will feel comfortable using them. It promotes data quality and has excellent graphics to represent your information through statistical processes.

Incentivized

• The software manages DB2 objects and navugate catlog easily.
• The BMC AMI Data helps our team in reducing DBA related work.
• The software also helps us in improving sql query performances

Incentivized

• Out-of-the-box support for many different databases.
• Intuitive UI for interacting with data.
• Flexibility of SQL Commander for writing scripts.
• Great support for working with JSON data in recent updates.
• Database connections over SSH.
• Table relationship visualization is very helpful.
• The tree view is well organized in how it splits out schemas.

• I like and enjoy this tool because it is intuitive and straightforward; its interface and panels are for managing local and remote databases.
• It is beneficial and powerful for database administration and has extensive support for handling multiple database engines.
• DataGrip's features and functionalities are excellent; they make our work easier and faster.
• We can manage several databases at the same time.

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

• Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
• Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
• (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)

• An easier way to have a pool saved queries that can opened quickly

Incentivized

We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.

Incentivized

BMC AMI Data helps our company keep most crucial data fast, accurate and trusted. It gives us sales insights helps in building next projections. It has got smarter real time inventory planning gives me a high trust on numbers and lastly if make right decision for my company profits it gives me a stronger leadership presence

Incentivized

I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.

Usability has two aspects, being a complete tool and being easy... DataGrip has a lot of features but it is big, not clear how to use most of the things and most people won't need them. In my opinion, usability is good enough but not friendly.

Never used

Incentivized

See all of the software have different attributes and working process they gives the different analytical results so I will not compare them directly to BMC AMI Data but I would say they all are pioneers platform at their own level.

Incentivized

[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.

Incentivized

DataGrip provides a single UI for many DBMS platforms, instead of using one for each. Because of that, you can migrate things between platforms using the tool and "look across" all databases at once.

Incentivized

• improve the availability, consistency and efficiency
• still not fully utilized the functionality that tool provides
• lots to learn for automation and AI/ML etc.

Incentivized

• Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
• Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
• Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily

• It has been perfect for detailed analysis of clients and companies; it gives us the competitiveness we were always looking for.

Incentivized