BMC AMI DevX vs Pentaho Data Integration and Analytics comparison

The compared BMC and Hitachi Vantara solutions aren't in the same category. BMC is ranked #6 in TDM , with an average rating of 7.7, and holds a 10.8% mindshare in the category. Hitachi Vantara is ranked #11 in DI , with an average rating of 7.6, and holds a 1.5% mindshare. Additionally, 90% of BMC users are willing to recommend the solution, compared to 95% of Hitachi Vantara users who would recommend it.

BMC AMI DevX

Read 19 BMC AMI DevX reviews

4,427 Views
354 Comparison Views

90% willing to recommend

Pentaho Data Integration an...

Read 59 Pentaho Data Integration and Analytics reviews

3,113 Views
2,428 Comparison Views

95% willing to recommend

BMC AMI DevX

Pentaho Data Integration an...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between BMC AMI DevX and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.

Find out in this report how the two Test Data Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed BMC AMI DevX vs. Pentaho Data Integration and Analytics Report (Updated: December 2025).

Buyer's Guide

BMC AMI DevX vs. Pentaho Data Integration and Analytics

December 2025

Download the complete report

Helped 881,114 peers since 2012

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

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)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (11th)

Mindshare comparison

BMC AMI DevX and Pentaho Data Integration and Analytics aren’t in the same category and serve different purposes. BMC AMI DevX is designed for Test Data Management and holds a mindshare of 10.8%, up 3.6% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.5% mindshare, up 1.3% since last year.

Test Data Management Market Share Distribution
Product	Market Share (%)
BMC AMI DevX	10.8%
Perforce Delphix	22.8%
Broadcom Test Data Manager	13.1%
Other	53.3%

Test Data Management

Data Integration Market Share Distribution
Product	Market Share (%)
Pentaho Data Integration and Analytics	1.5%
SSIS	4.0%
Informatica Intelligent Data Management Cloud (IDMC)	3.7%
Other	90.8%

Data Integration

Featured Reviews

Brian Westerman

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.

Read full review

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

Streamlines complex data workflows and has supported automated customer payment notifications

I haven't used Pentaho Data Integration and Analytics in a couple of years, so I don't know how it can be improved. I was pretty pleased with it and was self-taught on it, working a lot with their team at various times, but they were surprised that I was able to learn it all by myself. The documentation is not bad, and documentation is the main thing that any product can do to make themselves better because the easier it is to find examples of what you're trying to do improves the learning curve. I think it took me the longest to learn how to do the asynchronous processing and have things wait for other things to finish processing before continuing on in the workflow. I choose 8 out of 10 because the one reason that it's been rejected at T-Mobile is that everything has to go through a provisioning process and has to get approved, meaning the actual code base has to be investigated by T-Mobile before they'll allow us to use tools of that nature. For whatever reason, we just haven't been able to get that approval; I don't know if it's on Pentaho Data Integration and Analytics' side or if it's on our side. The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.

Read full review

Quotes from Members

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

Pros

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

"The visual ability to see potential downstream impacts to changes being made assists our developers in understanding the impact associated with their change."

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

"It does our CICS NEWCOPYs and our Db2 binds for us, whereas before, that was a manual process. It takes a lot of the workload off of the operations folks and off the DBAs."

"The most valuable feature of Topaz is Xpediter. It's more flexible than Xpediter through MVS."

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

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

"It helps our staff work by speeding up their documentation process."

More BMC AMI DevX pros

"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."

"Pentaho Data Integration and Analytics positively impacted my organization by organizing data that was scattered across many different databases and APIs, reducing a lot of manual work and centralizing it into one data warehouse."

"Data transformation within Pentaho is a nice feature that they have and that I value."

"I find the drag and drop feature in Pentaho Data Integration very useful for integration."

"Since we started using Pentaho Data Integration and Analytics, many of our manual tasks have become automatic, and we have increased our time for productive things."

"Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing."

"Pentaho Data Integration and Analytics has positively impacted my organization by saving costs, managing large data sets, and integrating multiple sources."

"The abstraction is quite good."

More Pentaho Data Integration and Analytics pros

Cons

"It's a very complicated tool."

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

"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?"

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

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

"I'm always looking for improvement in things like the documentation, to make things a little bit easier and simpler to understand, a place where people can go to troubleshoot issues."

"It often doesn't play well with other plugins in the environment."

More BMC AMI DevX cons

"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."

"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."

"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."

"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."

"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."

"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."

"When dealing with substantial data volumes from cloud systems, performance can become an issue; even using the Enterprise Edition, the time required for executing particular pipeline tasks is notably high compared to other ETL tools such as ADF, DataBricks, or SSIS."

"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."

More Pentaho Data Integration and Analytics cons

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

"The price point is great."

"It has saved our developers time and effort when working on documentation, which is now more readable and fluent."

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

"I like the seat-based licensing much more than MSU-based licensing, and that the cost has been competitive."

"I mostly used the open-source version. I didn't work with a license."

"There is a good open source option (Community Edition)."

"I primarily work on the Community Version, which is available to use free of charge."

"The solution reduced our ETL development time by a lot because a whole project used to take about a month to get done previously. After having Lumada, it took just a week. For a big company in Brazil, it saves a team at least $10,000 a month."

"We are using the Community Edition. We have been trying to use and sell the Enterprise version, but that hasn't been possible due to the budget required for it."

"The price of the regular version is not reasonable and it should be lower."

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

"I use it because it is free. I download from their page for free. I don't have to pay for a license. With other tools, I have to pay for the licenses. That is why I use Pentaho."

More Pentaho Data Integration and Analytics pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.

See recommendations

881,114 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

34%

Insurance Company

12%

Manufacturing Company

Government

Financial Services Firm

14%

Educational Organization

Computer Software Company

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	6
Large Enterprise	16

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	18
Large Enterprise	29

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

See all answers

What needs improvement with Compuware File-AID?

See all answers

What is your primary use case for Compuware File-AID?

We use the solution clone test files.

See all answers

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

See all answers

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

See all answers

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

See all answers

Comparisons

Endevor vs BMC AMI DevX

Compared 19% of the time

IBM File Manager vs BMC AMI DevX

Compared 11% of the time

InterTest vs BMC AMI DevX

Compared 7% of the time

IBM Debug for z/OS vs BMC AMI DevX

Compared 6% of the time

Broadcom Test Data Manager vs BMC AMI DevX

Compared 5% of the time

More BMC AMI DevX Competitors

Airbyte Cloud vs Pentaho Data Integration and Analytics

Compared 11% of the time

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 8% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 8% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 7% of the time

Qlik Talend Cloud vs Pentaho Data Integration and Analytics

Compared 6% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

BMC AMI DevX

January 2026

Download BMC AMI DevX product report

Buyer's Guide

Pentaho Data Integration and Analytics

January 2026

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Also Known As

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

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Overview

BMC AMI DevX is a comprehensive solution enhancing code management and testing efficiency. It offers debugging capabilities within financial applications and integrates data management seamlessly, serving major banking sectors with reliable performance.

AMI DevX is tailored for banking industries, optimizing application debugging in COBOL and enhancing data handling in robust financial systems. It simplifies mainframe data management with real-time insights, improving efficiency through editing and cloning functionalities. The tool's integration with Compuware File-AID for IMS and DB2 ensures streamlined development processes. Challenges include a steep DB2 learning curve and initial setup complexities, with technical support inconsistencies and steep pricing impacting affordability. Despite this, its valuable features significantly support large banking operations.

What features make BMC AMI DevX valuable?

Line-by-Line Code Debugging: Allows precise identification and rectification of issues.
Variable Change & Line Skipping: Flexibility in testing without recompiling.
Database-Independent Testing: No need for loading databases during testing.
Real-Time Data Insights: Enhances decision-making with immediate information.
Data Warehousing & Analytics: Facilitates comprehensive data analysis.
Integration & Formatting: Streamlines development by simplifying data processes.

What benefits should users look for in reviews?

Improved Efficiency: Streamline data management and editing capabilities.
Robust Debugging: Effective in both online and batch COBOL program debugging.
Enhanced Financial Application Support: Superior handling in grants and loans applications.
Comprehensive Testing: Enables creation of clone test files for thorough testing.

In large banking sectors, BMC AMI DevX is integral for grants and loans-related applications. Its robust nature supports financial systems, offering debugging for COBOL, updating data in Compuware File-AID for IMS, and integrating DB2. Users implement this for exceptional data management and application reliability.

BMC

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Hitachi Vantara

Sample Customers

Helvetia, The IMT Group, Hapag-Lloyd, Royal Bank of Canada, Chunghwa Telecom

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

Buyer's Guide

BMC AMI DevX vs. Pentaho Data Integration and Analytics

December 2025

Free Report: BMC AMI DevX vs. Pentaho Data Integration and Analytics

Find out what your peers are saying about BMC AMI DevX vs. Pentaho Data Integration and Analytics and other solutions. Updated: December 2025.

DOWNLOAD NOW

881,114 professionals have used our research since 2012.

See our BMC AMI DevX vs. Pentaho Data Integration and Analytics report.

We monitor all Test Data Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.