Try our new research platform with insights from 80,000+ expert users

BMC AMI DevX vs IDERA SQL Diagnostic Manager for SQL Server comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 11, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

BMC AMI DevX
Ranking in Database Development and Management
19th
Average Rating
8.0
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
Software Configuration Management (1st), Debugging (9th), Mainframe Application Development (1st), Test Data Management (7th), Mainframe Testing Tools (1st), Data Masking (8th)
IDERA SQL Diagnostic Manage...
Ranking in Database Development and Management
11th
Average Rating
8.0
Reviews Sentiment
7.4
Number of Reviews
9
Ranking in other categories
Event Monitoring (11th)
 

Mindshare comparison

As of November 2025, in the Database Development and Management category, the mindshare of BMC AMI DevX is 1.3%, up from 0.5% compared to the previous year. The mindshare of IDERA SQL Diagnostic Manager for SQL Server is 4.0%, up from 3.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management Market Share Distribution
ProductMarket Share (%)
IDERA SQL Diagnostic Manager for SQL Server4.0%
BMC AMI DevX1.3%
Other94.7%
Database Development and Management
 

Featured Reviews

Brian Westerman - PeerSpot reviewer
Helps to make mainframe data management process easier and saves manhours
We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its initial cost. We would need to pay around 60,000 dollars to have all three products together. We also encountered issues during version updates.
reviewer2317098 - PeerSpot reviewer
Offers effective monitoring of resources but lacks the ability to connect to an AWS instance and write custom queries.
We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes We've set up alerts to notify us when performance deviates from the baseline we've configured for each resource. So, whenever that happens, we get an alert and can investigate immediately. So,…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We had parallel development before, but the way ISPW implements it is better. It has more control and oversight of the process, whereas before, it was like the Wild West. Everybody could have their own package with their own version of the component in it... ISPW is constantly aware of it. It notifies when someone else is using or has a different version of that component."
"I like the ability that it has to format copy books in a presentable manner. So, you will be able to see the starting offset in length of each field within the layout."
"One of the features that the developers like is that they can retrieve what they need with the tool. They don't have to go through some process or request something be done by another team. They can get the programs they need, compile them, retrieve the JCL and alter the JCL if they need to, and put these programs wherever they need to go for their testing."
"I have worked with DB2's great features in the last five years. The IDAA feature transformed the vision of warehousing, business analytics, and big data at my bank. Besides the mainframe, I saw that this solution was evolutionary. It gives real-time information."
"I like the ability to flow through the source and see what happens to the data as the statements are executed. If there is a fault, it will track the event, and we can then look back to see why it may have caused the fault. You can also reverse engineer your test. You can set it so that you can go backward as well as forward in your test. This is something that I haven't done here at my company. Compuware Xpediter is one of the best debugging tools for mainframe software development. We have currently licensed only the COBOL language for Xpediter, but I know they have other languages, including Assembler, PL/I."
"The most valuable feature of Topaz is Xpediter. It's more flexible than Xpediter through MVS."
"Once we got the configurations and deployment rolled out, it was very stable. I haven't had any major issues with Eclipse or the Topaz Workbench plugins."
"It's a modernized development portal and helps reduce the learning curve for younger people coming in to work on the platform,"
"The best part of SQL DM is the ability to customize alerts and counters. This allows our team to find an issue then alert on the issue at a granular level."
"The ability to go back and look at historical data is the most valuable feature."
"We're able to diagnose issues prior to their actually becoming issues. Without the alerting, we wouldn't have a clue as to what was going to happen. With the alerting, it gives us a heads-up that a specific threshold has been met, and we need to take specific action."
"Monitors and alerts on our mission critical instances in real-time on a 24/7 basis."
"The most valuable features are disk space projections for planning, and also the Snapshotting ability, to look back in time, to see what was going on the server at a particular time. It's basically the output of an sp_who2."
"SQL DM made troubleshooting much easier and allowed multiple people to look into an issue with confidence."
"Memory and CPU utilization features are good."
 

Cons

"The solution could be improved by being better integrated with the open world. In the next release, I would like to have the ability to work in an open environment whilst remaining integrated with the legacy environment."
"The area for improvement is related to the testing tools that are available for unit testing or acceptance testing. I know they have some out there that we are not licensed for at this time, but it seems like some of the Eclipse tools that are used for other programming languages, they're all just built-in and they're a little more intuitive to the developers. Making those testing tools as intuitive as possible, and as integrated as possible into the workbench, would be really beneficial."
"It's not as intuitive as it should be. In terms of navigation, there is a large training curve for using it. For a millennial it might be better, if they're used to Eclipse. But coming from a non-Eclipse environment and using Eclipse, though I have experience with Eclipse, it might be cumbersome."
"DB2 is a hard tool to grasp. It's hard for users to learn how to use it. It's not easy to see how it works."
"The ability to edit source code that has special characters is limited. The ability to incorporate or convert REXX into macros that are usable under the Topaz software is not there. And the REXX macros that I have developed over 40 years of work are useless, so I have a toolbox I can't use or deploy using the Topaz technology, while I can use it under MVS."
"We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its initial cost. We would need to pay around 60,000 dollars to have all three products together. We also encountered issues during version updates."
"It would be nice to have an audit trail to see what mainframe developers are using what."
"Their technical support could be better. There were times where, when we reported bugs, they would fix one bug but add another one. That's probably because of their support model. A lot of organizations are developing software using Agile rather than the Waterfall method, so things are happening all over the place. You get things quicker, but sometimes one fix will break another one or add other bugs."
"The initial setup gives too many user rights to the server, so you have to put a user that is part administrator's group - that's the preferred way - on each server, which is kind of a risk. You want to do least privilege and you're not doing that."
"One thing I'd like to see is the ability to view the execution plan and have the system automatically recommend potential query optimizations, especially at the query level."
"I would absolutely love to create customized dashboards but, unfortunately, they don't provide me the information that I need to create the report. The report I need is the detail or the transaction detail that's happening on those Snapshots. I'd like to be able to go back through time and search for things. I don't have that functionality, which is very disappointing. That's pretty bad and frustrating because I could query it and find out so much information about what's hitting my environment and when, but instead, they want control over it and to not give me that information. So it's encrypted. I can't pull it out and that is really bothersome."
"It would helpful if SQL DM could mark when changes are made within the program."
"We don't find that it helps us with performance monitoring and diagnostics. We find that SentryOne does that better. Also, in terms of alerts, we had to customize them dramatically so that we didn't get alerted on every little thing."
"I'm going to do an upgrade which may resolve my issues, but one area for improvement is its ability to handle the amount of data that we collect with it. We're likely one of the largest installations, with over 300 servers being collected with this product, and sometimes there are gaps. That would really be my only concern, in terms of how the data is collected and stored, for consistency."
"They can improve checking the status of the CPU, memory, and IO utilization from each task."
 

Pricing and Cost Advice

"In general, Compuware tools are very competitive."
"The price point is great."
"In terms of pricing, there isn't an extra charge for the parts of it we use. It comes with the licenses we purchased for other products, so no complaints there. The licensing is built in with the other products that you purchase from Compuware."
"The only thing I would mention related to the licensing and/or the pricing, is that they have some visualization features in there that are licensed by concurrent users. We're starting to trip up on that. We're looking to probably increase the number of concurrent licenses that we have. But those types of licensing strategies, where they license by concurrent users or the number of seats is confusing for some people. They don't understand why it works sometimes and doesn't work other times."
"It has saved our developers time and effort when working on documentation, which is now more readable and fluent."
"I like the seat-based licensing much more than MSU-based licensing, and that the cost has been competitive."
"The pricing is reasonable, it's comparable with the competitors."
"We were upgraded to Premium Support without their actually asking us, when we were quoted. Then I asked for Standard Support and that they had to re-quote us that. But they don't do that by default. They upcharge you by default, which I didn't think was very nice, without even asking."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
872,922 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
36%
Insurance Company
12%
Computer Software Company
8%
Manufacturing Company
7%
Comms Service Provider
9%
Financial Services Firm
9%
Insurance Company
8%
Healthcare Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business6
Large Enterprise16
By reviewers
Company SizeCount
Small Business3
Midsize Enterprise5
Large Enterprise4
 

Questions from the Community

What do you like most about Compuware File-AID?
The product has made our mainframe data management process easier. It has helped us save manhours. The tool's most valuable feature is the ability to edit tape files. Its ability to clone files is ...
What needs improvement with Compuware File-AID?
We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its...
What do you like most about IDERA SQL Diagnostic Manager for SQL Server?
The ability to go back and look at historical data is the most valuable feature.
What needs improvement with IDERA SQL Diagnostic Manager for SQL Server?
One thing I'd like to see is the ability to view the execution plan and have the system automatically recommend potential query optimizations, especially at the query level. In future releases, I w...
What is your primary use case for IDERA SQL Diagnostic Manager for SQL Server?
We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes.
 

Also Known As

File-AID, Data for Db2, Code Debug, Data Studio, Workbench for Eclipse, Code Pipeline
IDERA SQL DM, IDERA SQL Diagnostic Manager
 

Overview

 

Sample Customers

Helvetia, The IMT Group, Hapag-Lloyd, Royal Bank of Canada, Chunghwa Telecom
Padnos, University of Notre Dame, D4, Infeon Technologies, Chevron, LC Waikiki, Sisters of Saint Francis Health Services, Seattle Cancer Care Alliance, CVE, Colorado State University, St. Charles, Chaucer PLC, 1-800-Flowers, Ancoris, Money Management, National Opinion Research Center, California Department of Health, Plexus; Aviva, Burlington Northern Santa Fe, CBS, Comcast, Google, Merck, Regions Financial, Schneider Electric, Tata Consultancy Services, Verizon Communications, Zurich Financial Services
Find out what your peers are saying about BMC AMI DevX vs. IDERA SQL Diagnostic Manager for SQL Server and other solutions. Updated: October 2025.
872,922 professionals have used our research since 2012.