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 (8th), Database Development and Management (20th), Mainframe Application Development (1st), Test Data Management (7th), Mainframe Testing Tools (1st), Data Masking (8th)
Denodo
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
37
Ranking in other categories
Data Integration (9th), Data Virtualization (1st), Cloud Data Integration (5th)
 

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.
Atanu Chatterjee - PeerSpot reviewer
Data virtualization and integration enabled while caching and scalability room for improvement
In terms of improvements for Denodo, regarding performance, in cases where there are multiple virtualizations—such as reading from one Denodo view that is virtualized, and from that view there's also virtualization, and another team is reading from that view—if multiple virtualizations happen with no caching in between, it becomes slow. This occurs because it is cascading; whenever at the top level someone is reading data, that request is getting cascaded to the nth level, causing issues, especially in cases such as Power BI reports. We need to consider implementing some persistent layer in between. The scaling process should improve because many things are getting automated. The scale-out part needs to be automated, though I am uncertain whether Denodo has already implemented that feature.

Quotes from Members

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

Pros

"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."
"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."
"BMC Data Management improved our data recovery process by simplifying it."
"The most valuable feature of Topaz is Xpediter. It's more flexible than Xpediter through MVS."
"It's a modernized development portal and helps reduce the learning curve for younger people coming in to work on the platform,"
"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."
"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."
"From a user perspective, the GUIs make it easier for people to see and interact with files on the mainframe."
"It is a very stable solution."
"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."
"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"The ability to transfer data is very valuable."
"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."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"The data catalog feature is valuable as it helps define data structures without storing data."
"The performance and the speed to market are the most valuable features of this solution."
 

Cons

"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."
"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."
"It often doesn't play well with other plugins in the environment."
"It would be nice to have an audit trail to see what mainframe developers are using what."
"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."
"It would be good if the vendors would work together or at least have some collaboration between them, so they would know what would work and what wouldn't work. Right now, the way things are working, they're relying on the customer to make everything work."
"There are some features that are not well documented, so documentation could use a little help, on things like setting up deployment and which structures in the database correspond to which tables."
"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?"
"We can't scale it to meet digital requirements."
"Denodo needs better communication on how the product can be deployed for specific solutions, and there are price issues, as it's considered expensive."
"I am still waiting for Denodo to support vector databases."
"The support is not the best and should be improved."
"It would be good if the solution provided a much-needed cellular platform."
"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."
"There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."
"I would like to see a proper way to avoid killing the sourcing systems."
 

Pricing and Cost Advice

"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."
"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."
"It has saved our developers time and effort when working on documentation, which is now more readable and fluent."
"The price point is great."
"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."
"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."
"For us, the cost has been okay. Also, there are no additional costs; it's just the standard licensing fee."
"Denodo provides a lightweight 30-day free trial, but when we do courses on top of it, it costs $150 for each person."
"The licensing should be improved, as the cost per connector is quite expensive."
"The licensing charges for this solution are payable annually."
"I don't know the actual cost, but it's tens of thousands of dollars per month."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
869,771 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
36%
Insurance Company
12%
Computer Software Company
7%
Manufacturing Company
7%
Financial Services Firm
24%
Manufacturing Company
11%
Computer Software Company
8%
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 Business13
Midsize Enterprise6
Large Enterprise19
 

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

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: September 2025.
869,771 professionals have used our research since 2012.