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

BMC AMI DevX vs Denodo comparison

 

Comparison Buyer's Guide

Executive Summary

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
Average Rating
8.0
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
Software Configuration Management (1st), Debugging (6th), Database Development and Management (17th), Mainframe Application Development (1st), Test Data Management (6th), Mainframe Testing Tools (1st), Data Masking (7th)
Denodo
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
40
Ranking in other categories
Data Integration (8th), Data Virtualization (1st), Cloud Data Integration (5th), Data Management Platforms (DMP) (3rd), AI Data Analysis (4th)
 

Featured Reviews

Brian Westerman - PeerSpot reviewer
Director of R&D at Syzygy Inc.
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.
Douglas Camargo - PeerSpot reviewer
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
Has simplified multi-database querying and accelerated solution delivery with minimal setup
Denodo offers a great query language, the VQL, which was very easy to understand for someone that only knows SQL. It was easy to work with, and it was easy to integrate various types of databases in general. The usability of the platform is very great. The federated queries were also a feature that I used a lot. The easy usability of Denodo helped my work and made things easier for productivity. We were able to ship code faster than if we needed to use another type of data visualization tool or even an ETL. When we have multiple databases, the standard or common approach is just to have an ETL that matches the data, and we need to write this whole ETL. With Denodo, we can simplify this whole work to a few queries or setups in the databases and just make a few queries. This was actually easier, and it was faster to deliver a solution for a client instead of building a whole ETL pipeline or simply backfilling one database in another. Denodo simplifies your work and helps you ship code or ship solutions in a faster way. I really like the UI that Denodo has on the web app version. It was very simple and actually very beautiful to see. For a complicated program, it was very easy to understand how it works, even for someone who is just approaching the data engineering career or side of the programming language.

Quotes from Members

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

Pros

"We can develop in parallel today on ISPF, but it's giving us the advantage of the newer interface into the mainframe programming languages that younger programmers can use and are familiar with, rather than using the ISPF green screen."
"I think the most valuable features are code management, code deployment, and code generation. The fact that those three features are included makes BMC Compuware ISPW a robust product. If one of those features was missing, it would be less robust and less interesting. But because it has those three features, it is a very good solution for code development and management."
"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 beneficial in application development."
"From a user perspective, the GUIs make it easier for people to see and interact with files on the mainframe."
"The visual ability to see potential downstream impacts to changes being made assists our developers in understanding the impact associated with their change."
"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 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."
"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."
"Denodo provides high reliability, with features like vertical scaling, horizontal scaling, and failover nodes."
"The logical data warehouse functionality is fantastic. It truly stands out. The ClearOptimizer and Virtual Cache are great features. They work together seamlessly to optimize performance."
"This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"We can consume data fast."
"The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently."
"The most valuable feature in Denodo is data virtualization."
"It is a very stable solution."
"The GUI interface allows easy connection of all data sources like API, JSON, or any JDBC source."
 

Cons

"One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution."
"When you're setting up the parameters for how ISPW will work in your shop, there are a lot of questions that have to be answered... BMC Compuware should have more in-depth explanations about what the choices in each question mean. If you pick A, what does that mean has to happen? What does that impact? If you pick B, what does that mean? What does that impact?"
"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."
"I'm waiting to see what 19.2 for Topaz looks like, but I have a problem with the JES Explorer right now. It limits you to a certain prefix for job names and there are some groups that have multiple prefixes that they'd like to see all at once in their job names, because of how they work in a group. And they can't see that in the JES Explorer."
"It often doesn't play well with other plugins in the environment."
"Better discussions to identify inventory prior to the start of any migration would be helpful for potential clients that have applications with code that is not modified often."
"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."
"Technical support has gotten better over the years, though there's always room for improvement."
"User-specific security at the column and row levels needs to be improved. Instead of applying security at every individual level, it would be better if it were at the group or tier level. It will save a lot of time."
"Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume."
"The stability of the features can be improved."
"The solution is slow when there are many virtualization layers."
"Lacks integrations with AWS, GCP and the like."
"I would like it if we could pull the data model or export the data model because Denodo has, based on how you build, something called associations. The data model gets very confusing when you go look at it. It depends on how you define it, but it's really huge. I wish there was a way to export it into Visio. It could be that they already have a way to do it, and I don't know, but it would be much easier for the architects and even for the developers to look at it than scrunching it into the screen and expanding every small portion of it. If there was an easy way to export the Denodo model into another modeling tool and view it, it would be great."
"In my opinion, it's very expensive. For small companies, it's not a solution that most small companies can afford."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
 

Pricing and Cost Advice

"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."
"I like the seat-based licensing much more than MSU-based licensing, and that the cost has been competitive."
"In general, Compuware tools are very competitive."
"It has saved our developers time and effort when working on documentation, which is now more readable and fluent."
"The cost for Denodo is in line with other similar products."
"I am not super familiar with the pricing, but so far, it seems good. We have been happy. We haven't seen any problems. The only time we had to pay extra was during the upgrade. We didn't upgrade at the time they told us to upgrade, and we had to pay extra to keep the service. They had stopped the support for the older version and moved to the newer version. It was not their fault. It was our fault because we didn't get on board quickly."
"Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
"The licensing should be improved, as the cost per connector is quite expensive."
"I don't know the actual cost, but it's tens of thousands of dollars per month."
"Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."
"The pricing is pretty good, and I would rate it at four out of five."
"Denodo provides a lightweight 30-day free trial, but when we do courses on top of it, it costs $150 for each person."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
881,114 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
34%
Insurance Company
12%
Manufacturing Company
7%
Government
6%
Financial Services Firm
23%
Manufacturing Company
12%
Computer Software Company
7%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business6
Large Enterprise16
By reviewers
Company SizeCount
Small Business15
Midsize Enterprise6
Large Enterprise20
 

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...
Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit from it, including administrators, developers, and architects. If you are keen on i...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I think make the product less good or effective. The only thing I can point out is...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data fabric Master data management In my opinion, organizations in different fields...
 

Comparisons

 

Also Known As

File-AID, Data for Db2, Code Debug, Data Studio, Workbench for Eclipse, Code Pipeline
No data available
 

Overview

 

Sample Customers

Helvetia, The IMT Group, Hapag-Lloyd, Royal Bank of Canada, Chunghwa Telecom
Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
Find out what your peers are saying about BMC AMI DevX vs. Denodo and other solutions. Updated: December 2025.
881,114 professionals have used our research since 2012.