No more typing reviews! Try our Samantha, our new voice AI agent.

ETL Solutions Transformation Manager vs Pentaho Data Integration and Analytics comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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

ETL Solutions Transformatio...
Ranking in Data Integration
53rd
Average Rating
9.0
Reviews Sentiment
6.8
Number of Reviews
3
Ranking in other categories
No ranking in other categories
Pentaho Data Integration an...
Ranking in Data Integration
7th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
60
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of May 2026, in the Data Integration category, the mindshare of ETL Solutions Transformation Manager is 1.0%, up from 0.2% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.7%, up from 1.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Pentaho Data Integration and Analytics1.7%
ETL Solutions Transformation Manager1.0%
Other97.3%
Data Integration
 

Featured Reviews

Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions
It lets us create models so we can generate real-time predictions and insights for a our clients
Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing. I would like it if we could set the solution up to process and respond to real-time events. For example, say I want to configure an app to run based on the mileage a car has driven, and I configure the metering system, so the event occurs every 15 days. Let's say we want to automatically send an alert to EMS, police, etc. if a car gets into an accident. Transformation Manager is more of a conventional tool for reporting, extracting volume, bulk loading, etc. but there should be more provisions for dealing with real-time events, creating some insights, and dealing with perishable data. Ten minutes after the accident, the data doesn't have value. It has value before you saved the person.
Michelle Lawson - PeerSpot reviewer
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.

Quotes from Members

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

Pros

"Transformation Manager is the backbone of every data pipeline these days because the solution has been on the market for 20 to 30 years, and we use it for various industries, including financial services, manufacturing, healthcare, etc."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
"It is among the best, even if not widely known."
"It is a reliable solution."
"The most valuable thing for me is that it enables a technical product manager to be able to write ETL jobs themselves, which saves developers time so that they can do more important things."
"As a result of one of the projects that we did in the Middle East, we achieved the main goal of fully digitalizing their population census."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"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."
"The speed of developing solutions has been the best improvement, reducing development time by days or weeks compared to using a different tool."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."
"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."
 

Cons

"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
"We get decent support. It's okay but not great."
"There is room for improvement in the solution's visualization tool."
"They should build a functional architecture based on queuing."
"It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively."
"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."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"One thing that I don't like, just a little, is the backward compatibility."
"​I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support.​"
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured."
"Support for common Hadoop utilities can be expanded, such as bulk load with composite row keys for HBase, and include drivers for Impala out-of-the-box."
 

Pricing and Cost Advice

"It is an expensive solution."
"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."
"I think Lumada's price is fair compared to some of the others, like BusinessObjects, which is was the other thing that I used at my previous job. BusinessObject's price was more reasonable before SAP acquired it. They jacked the price up significantly. Oracle's OBIEE tool was also prohibitively expensive."
"If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"
"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."
"I primarily work on the Community Version, which is available to use free of charge."
"There is a good open source option (Community Edition)​."
"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."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
894,738 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Construction Company
14%
Computer Software Company
12%
Outsourcing Company
11%
Retailer
8%
Financial Services Firm
15%
Educational Organization
8%
Government
7%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business18
Midsize Enterprise17
Large Enterprise31
 

Questions from the Community

Ask a question
Earn 20 points
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...
 

Also Known As

Transformation Manager
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

Honda, BNP Paribas, RBS, JPMorgan, Volkswagen, Thorn Lighting, OpenSpirit, Rolls-Royce, Ulster Bank
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about ETL Solutions Transformation Manager vs. Pentaho Data Integration and Analytics and other solutions. Updated: May 2026.
894,738 professionals have used our research since 2012.