BMC AMI DevX vs Pentaho Data Integration and Analytics comparison

BMC AMI DevX vs. Pentaho Data Integration and Analytics

April 2026

Download the complete report

Helped 894,738 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:

ROI

Sentiment score

1.0

BMC AMI DevX boosted efficiency, halving project time, reducing errors, and saving a day weekly in programming efforts.

Sentiment score

7.4

Pentaho and Lumada integration improved efficiency, reduced costs, and enhanced decision-making speed, benefiting companies' competitiveness and project wins.

No quotes available

For more quotes and insights, download the BMC AMI DevX report

I have seen a return on investment; my team was able to stay extremely small even though we had a lot of data integrations with many companies.

Michelle Lawson

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

I can testify to the return on investment with metrics regarding time saved; we have increased our efficiency by about 20 to 30 percent due to the swift migration processes facilitated by the tool.

Data Integration Developer at a tech services company with 1,001-5,000 employees

I have noticed a return on investment with Pentaho Data Integration and Analytics in terms of time savings and staff reduction.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Customer Service

Sentiment score

6.7

BMC AMI DevX support is responsive and effective, though complex issues may need more experienced staff for resolution.

Sentiment score

5.1

Pentaho support experiences vary; some note effectiveness, others delays, with community forums often supplementing Enterprise's speedy ticket responses.

Every time I open a case, I get an immediate response.

For more quotes and insights, download the BMC AMI DevX report

Devops Engineer / Ispw Admin at a insurance company with 201-500 employees

24/7 assistance is available for the Enterprise Edition.

Jayakrishnanmg MG

Data architect at a tech vendor with 10,001+ employees

take the time to understand our business requirements, offering appropriate recommendations.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Integration Developer at a tech services company with 1,001-5,000 employees

Communication with the vendor is challenging

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

Scalability Issues

Sentiment score

6.8

BMC AMI DevX offers superior scalability and functionality, praised for global use and efficient access by various-sized companies.

Sentiment score

7.2

Pentaho Data Integration offers good scalability for moderate datasets but struggles with large volumes and cloud architectures.

BMC AMI DevX Code Pipeline runs on one LPAR, and no matter where someone is in the world, they have to use it on that LPAR.

For more quotes and insights, download the BMC AMI DevX report

Devops Engineer / Ispw Admin at a insurance company with 201-500 employees

It can be scaled well until you reach a point where you need to perform a lot of operations, and the issue arises when it runs out of memory to handle some data.

reviewer2787603

Data engineer at a educational organization with 1,001-5,000 employees

Its ability to scale horizontally in cloud-native architectures or for massive real-time processing is limited.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Pentaho Data Integration handles larger datasets better.

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

Stability Issues

Sentiment score

8.5

BMC AMI DevX is highly stable post-configuration, though occasional issues arise with new releases and frequent updates.

Sentiment score

7.2

Pentaho is stable and reliable, though minor bugs and performance issues occur, especially with older or complex queries.

No quotes available

For more quotes and insights, download the BMC AMI DevX report

Performance issues arise due to reliance on a flowchart-based mechanism instead of scripts, which can lead to longer execution times.

Jayakrishnanmg MG

Data architect at a tech vendor with 10,001+ employees

I find that version 3.1 is the most stable version I have ever used.

Alberto Pedro

Founder-CEO at Ubuntu Analytica

It's pretty stable, however, it struggles when dealing with smaller amounts of data.

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Room For Improvement

BMC AMI DevX users want improved vendor collaboration, compatibility, user interface, tutorials, and better disaster recovery and installation simplification.

Pentaho requires better cloud adaptability, scalability, real-time processing, modern UI, language support, performance, documentation, and environment compatibility.

I have to put my cursor on the field and tap it to bring focus there, or use the tab key multiple times to get to a field on the screen.

For more quotes and insights, download the BMC AMI DevX report

Devops Engineer / Ispw Admin at a insurance company with 201-500 employees

We should also explore more effective partitioning for parallel processing and fine-tuning database connections to reduce load times and improve ETL speed.

Data Integration Developer at a tech services company with 1,001-5,000 employees

Pentaho Data Integration and Analytics can be improved by working with different environments, specifically the possibility to change the variables, meaning I write my variables only once and can change them for different environments such as production or development.

Alberto Pedro

Founder-CEO at Ubuntu Analytica

Pentaho Data Integration and Analytics could have real-time processing and automatic alerting, having alerts or automatic notifications when a job fails or when certain data doesn't meet certain rules.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Setup Cost

BMC AMI DevX pricing is competitive, particularly with Topaz Workbench included, though confusion arises with certain licensed features.

Pentaho offers a cost-effective solution with appealing Community and Enterprise editions, maintaining positive sentiment despite some price increases.

No quotes available

For more quotes and insights, download the BMC AMI DevX report

I use the community version of Pentaho Data Integration and Analytics, and I do not need additional costs.

JuanCarlosMartinezLara

Project Manager at Laberit

The setup cost was minimal, and the pricing experience was pretty good.

reviewer2787603

Data engineer at a educational organization with 1,001-5,000 employees

The company covered it and they had no problem paying for it because they saw that it was cost-effective in terms of performance afterwards.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Valuable Features

BMC AMI DevX provides developer collaboration, code management, cloud access, visual tools, and Agile support, enhancing development efficiency.

Pentaho offers intuitive data integration with broad connectivity, simplifying complex transformations and providing flexibility and automation across environments.

With ISPW, developers can back out the entire release or entire package.

For more quotes and insights, download the BMC AMI DevX report

Devops Engineer / Ispw Admin at a insurance company with 201-500 employees

Pentaho Data Integration and Analytics has positively impacted my organization because it meant we didn't have to write a lot of custom API back-end processing logic; it did the majority of that heavy lifting for us.

Michelle Lawson

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

It automates the data workflow, including extraction, cleansing, and loading into warehouses for BI reporting purposes, while also removing duplicates, validating data, and standardizing formats, enabling real-time decision-making.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Integration Developer at a tech services company with 1,001-5,000 employees

Pentaho Data Integration and Analytics has positively impacted my organization because it is easier to use, and my knowledge about this work facilitates the translation from the source to my final system.

JuanCarlosMartinezLara

Project Manager at Laberit

Categories and Ranking

BMC AMI DevX

Average Rating

8.0

Reviews Sentiment

6.1

Number of Reviews

Ranking in other categories

Software Configuration Management (1st), Debugging (6th), Database Development and Management (16th), Mainframe Application Development (1st), Test Data Management (5th), Mainframe Testing Tools (1st), Data Masking (4th), AI Software Development (217th)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (7th)

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

Test Data Management Mindshare Distribution
Product	Mindshare (%)
BMC AMI DevX	11.9%
Perforce Delphix	17.8%
Broadcom Test Data Manager	14.0%
Other	56.3%

Test Data Management

Data Integration Mindshare Distribution
Product	Mindshare (%)
Pentaho Data Integration and Analytics	1.7%
SSIS	3.7%
Informatica Intelligent Data Management Cloud (IDMC)	3.6%
Other	91.0%

Data Integration

Featured Reviews

Tight deployment controls have secured production and simplified complex release rollbacks

Devops Engineer / Ispw Admin at a insurance company with 201-500 employees

The best feature of BMC AMI DevX Code Pipeline that impresses me is the fallback functionality. The fallback functionality impresses me because when developers deploy large releases involving multiple components, such as COBOL programs, underlying copy books, and CICS modules, backing out changes would typically become a nightmare. With ISPW, developers can back out the entire release or entire package. If they deployed 100 components and want to back out everything, they can do so with one function and back out all components without worrying about backing out each individual component. They can back out the entire deployment set, which handles everything and brings them back to the previous versions. Developers can also selectively back out a subset of the deployed components. They also have the ability to revert to not just the most previous version but can go back several versions if they choose to do so. This gives them a lot of flexibility.

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

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

894,738 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

33%

Insurance Company

11%

Manufacturing Company

Computer Software Company

Financial Services Firm

15%

Educational Organization

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	6
Midsize Enterprise	1
Large Enterprise	16

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	17
Large Enterprise	31

Questions from the Community

What is your experience regarding pricing and costs for BMC Compuware Topaz Enterprise Data?

I don't directly deal with the pricing side of the solution.

What needs improvement with BMC Compuware Topaz Enterprise Data?

It's a very complicated tool. Sometimes the customer wants better, faster transaction times. They want the solution to move as fast as possible. We're trying to scale and grow our application with ...

What is your primary use case for BMC Compuware Topaz Enterprise Data?

We do development for our customers and we use Topaz to do backend systems for some Latin American banks. It's for enterprise data. It runs on AWS. I'm working on performance testing to do batch pe...

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

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

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

IBM File Manager vs BMC AMI DevX

Comparisons

Endevor vs BMC AMI DevX

Compared 9% of the time

Compared 6% of the time

Broadcom Test Data Manager vs BMC AMI DevX

Compared 5% of the time

InterTest vs BMC AMI DevX

Compared 4% of the time

Perforce Delphix vs BMC AMI DevX

Compared 4% of the time

More BMC AMI DevX Competitors

Airbyte Cloud vs Pentaho Data Integration and Analytics

Compared 12% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 8% of the time

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

Compared 7% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 6% of the time

StreamSets vs Pentaho Data Integration and Analytics

Compared 5% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Download BMC AMI DevX product report

BMC AMI DevX

May 2026

Pentaho Data Integration and Analytics

April 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 and Analytics offers an intuitive platform for data workflows, enabling users to easily manage ETL processes across diverse data formats, ensuring seamless automation and development.

With its drag-and-drop interface, Pentaho allows for efficient ETL workflows without extensive coding. It supports a multitude of data formats and sources such as SQL, NoSQL, Hadoop, CSV, and JSON. Advanced features like metadata injection and API integration enable seamless automation. However, improvements in big data performance, better cloud service integration, and enhanced real-time processing capabilities can enhance user experience. Additional connectors and improved documentation are sought after by many. Providing support for more programming languages and optimizing memory usage also presents opportunities for enhancement.

What are the key features of Pentaho Data Integration and Analytics?

Drag-and-Drop Interface: Simplifies building workflows without coding.
Broad Data Support: Accommodates SQL, NoSQL, Hadoop, CSV, and JSON.
Advanced Automation: Leverages metadata injection and API integration.
Cost-Effectiveness: Offers value with comprehensive big data support.

What benefits should be evaluated in Pentaho reviews?

Versatility: Supports both on-premises and cloud solutions.
Data Integration: Facilitates seamless connection of disparate data sources.
Transparency: Enhances data management and reporting.
Scalability: Adapts to the growing data needs of organizations.

Pentaho is employed across finance, healthcare, and retail industries for ETL processes. It's instrumental in integrating data from ERP, SAP systems, Excel, and APIs to develop comprehensive reports and data models. Companies rely on its capabilities for both on-premises and cloud deployments, improving data transparency and management.

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