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 #7 in TDM , with an average rating of 7.7, and holds a 6.9% mindshare in the category. Hitachi Vantara is ranked #18 in DI , with an average rating of 7.7, and holds a 1.7% mindshare. Additionally, 90% of BMC users are willing to recommend the solution, compared to 94% of Hitachi Vantara users who would recommend it.

BMC AMI DevX

Read 19 BMC AMI DevX reviews

4,026 Views
242 Comparison Views

90% willing to recommend

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

2,447 Views
1,884 Comparison Views

94% 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: September 2025).

Buyer's Guide

BMC AMI DevX vs. Pentaho Data Integration and Analytics

September 2025

Download the complete report

Helped 869,760 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 (8th), Database Development and Management (20th), Mainframe Application Development (1st), Test Data Management (7th), Mainframe Testing Tools (1st), Data Masking (8th)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (18th)

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 6.9%, up 3.9% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.7% mindshare, up 1.1% since last year.

Test Data Management Market Share Distribution
Product	Market Share (%)
BMC AMI DevX	6.9%
Perforce Delphix	28.3%
Informatica Test Data Management (TDM)	15.3%
Other	49.5%

Test Data Management

Data Integration Market Share Distribution
Product	Market Share (%)
Pentaho Data Integration and Analytics	1.7%
Informatica PowerCenter	6.0%
SSIS	5.7%
Other	86.6%

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

Aqeel UR Rehman

BI Analyst at a computer software company with 51-200 employees

Transform data efficiently with rich features but there's challenges with large datasets

Currently, I am using Pentaho Data Integration for transforming data and then loading it into different platforms. Sometimes, I use it in conjunction with AWS, particularly S3 and Redshift, to execute the copy command for data processing Pentaho Data Integration is easy to use, especially when…

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

"It's a modernized development portal and helps reduce the learning curve for younger people coming in to work on the platform,"

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

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

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

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

"BMC Data Management improved our data recovery process by simplifying it."

"From a user perspective, the GUIs make it easier for people to see and interact with files on the mainframe."

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

More BMC AMI DevX pros

"It has improved our data integration capabilities."

"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."

"The product is user-friendly and intuitive"

"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."

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

"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."

"The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data."

"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."

More Pentaho Data Integration and Analytics pros

Cons

"Technical support has gotten better over the years, though there's always room for improvement."

"It's a very complicated tool."

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

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

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

"One thing I would really like to see some improvement on is the promotion diagnostic messages. It invokes utilities "under the covers" to copy components, and it does not echo back any of the error messages from those utilities."

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

More BMC AMI DevX cons

"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."

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

"Larger data jobs take more time to execute."

"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."

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

"I would like to see more improvements with AS400 DB2."

"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."

"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."

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

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

"In general, Compuware tools are very competitive."

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

"It does seem a bit expensive compared to the serverless product offering. Tools, such as Server Integration Services, are "almost" free with a database engine. It is comparable to products like Alteryx, which is also very expensive."

"The pricing has been pretty good. I'm used to using everything open-source or freeware-based. I understand that organizations need to make sure that the solutions are secure, and that's basically where I hit a roadblock in my current organization. They needed to ensure that we had a license and we had a secure way of accessing it so that no outside parties could get access to our data, but in terms of pricing, considering how much other teams are spending on cloud solutions or even their existing solutions, its price point is pretty good. At this time, there are no additional costs. We just have the licensing fees."

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

"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."

"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

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

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

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

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

869,760 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

36%

Insurance Company

12%

Computer Software Company

Manufacturing Company

Financial Services Firm

18%

Computer Software Company

11%

Government

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	17
Midsize Enterprise	16
Large Enterprise	25

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 29% of the time

IBM File Manager vs BMC AMI DevX

Compared 15% of the time

IBM Debug for z/OS vs BMC AMI DevX

Compared 9% of the time

InterTest vs BMC AMI DevX

Compared 9% of the time

IBM Developer for z/OS Enterprise Edition (IDzEE) vs BMC AMI DevX

Compared 6% of the time

More BMC AMI DevX Competitors

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

Compared 14% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 10% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 9% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 9% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 8% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

BMC AMI DevX

October 2025

Download BMC AMI DevX product report

Buyer's Guide

Pentaho Data Integration and Analytics

September 2025

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

September 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: September 2025.

DOWNLOAD NOW

869,760 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.