BMC AMI Data vs. DbVisualizer

BMC AMI Cloud Vault provides immutable cloud storage, allowing businesses to create secure, unchangeable copies of critical data for rapid recovery in the event of ransomware. >For organizations looking to move away from expensive Virtual Tape Libraries (VTL) or on-premises storage, BMC AMI Cloud Data is well-suited, as it supports backing up or archiving mainframe data directly to cloud object storage (e.g., AWS).

Incentivized

Seamlessly querying PostgreSQL/PostGIS, Oracle, SQL Server, and SQLite from one interface without switching tools. The intelligent autocomplete and schema browsing make it ideal for writing queries and understanding unfamiliar databases. Complex performance tuning, deep monitoring, and automated backup/recovery require specialized DBA tools. Performance degrades with tens or hundreds of thousands of rows; command-line tools or ETL solutions are better suited to bulk data processing.

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

• 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.

• 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)

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

My overall experience with BMC AMI data has been great so far because after installing this software in our business now we are able to work on long term projects and business expansions. The software has made sure that our team work more on analysis and strategic data management that's why I would like to give it 9 out of 10

Incentivized

It does what we need it for, which is manipulate data, check connections, visualize database structures, check on user rights, or even just version checks on the used databases. The 'type to get to table name' feature is often irrational in behaviour, which leads to frustration. The start-up time could be much better, and the UI changes between versions are sometimes a hassle for us when buttons are suddenly moved or their appearance changes. We use a wide variety of DBVis versions on customer installations (which use the once-bought version), and differences in the look and feel between versions sometimes slow us down.

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

• By shifting to AIOps-powered monitoring, customers halved unplanned mainframe outages, resulting in $1.4 million in retained profit over three years=50% Reduction in Unplanned Downtime.
• BMC AMI data solutions delivered a 217% ROI, with payback in under six months, enabling teams to deliver 3x more code to production.
• BMC AMI Data for Db2 users achieved a 6% reduction in MIPS consumption and realized significant cost savings by retiring outdated, non-automated systems.
• The ability to perform database reorganizations with zero downtime ensures critical business applications remain available, protecting revenue streams and customer experience.

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