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

Pentaho Data Integration and Analytics vs ibi DataMigrator 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

ibi DataMigrator
Ranking in Data Integration
34th
Average Rating
9.0
Reviews Sentiment
1.0
Number of Reviews
1
Ranking in other categories
No ranking in other categories
Pentaho Data Integration an...
Ranking in Data Integration
8th
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 April 2026, in the Data Integration category, the mindshare of ibi DataMigrator is 0.7%, up from 0.2% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.6%, up from 1.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Pentaho Data Integration and Analytics1.6%
ibi DataMigrator0.7%
Other97.7%
Data Integration
 

Featured Reviews

David_Hall - PeerSpot reviewer
Data Warehouse Analyst at a insurance company with 1,001-5,000 employees
Have seen support quality decline while still relying on long-standing data transformation features
I would assess the tool's error handling and logging features as part of it involves having a sampling thing. Depending on the definition of who's doing this, I used to work at a university where we looked at students who registered, and there were people who could register without specifying their gender. Most people know their gender. Some people would not put their birth date, so their date of birth was the default century. In 1989, we had hundreds of 89-year-olds because it was noted as 1900. What we would do is quickly assess that this is not reasonable; in a college setting, how many 89-year-olds are standing in line for freshman orientation? We could produce transformations on the fly. You can look at stuff, but ultimately, you need to go back to the data. There's logic involved; do you have to have a six-digit zip? Do you need the six plus four? It all depends on your criteria. It's doable, but it takes time, and if there's a lot of that, they usually hire people just to handle it. It's a tool that has its limitations; they haven't added wonderful features, and it's a GUI tool based on a desktop that you can run. Their manuals are pretty good, but we're not really using it actively, so I can't tell you everything right now.
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

"IBI has led the way for many years because they can read and write any data set."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"I find the drag and drop feature in Pentaho Data Integration very useful for integration."
"When I started doing it and did the migration so that all that ETL process would be done in Pentaho Data Integration and Analytics, I reduced the processing time from two and a half hours per run to seven minutes."
"We have seen at least 30% savings in terms of effort, which has helped us to price our service and products more aggressively in the market and win more clients."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"We have been able to expose data services through the use of CDA relying on the same database as the reporting tools, thus avoiding inconsistencies among the data shown by reports and data acquired by external systems."
"With this solution, instead of it taking a week, it was reduced to an afternoon, or about three hours."
"Using the solution we were able to reduce our ETL deployment time by between 10 and 20 percent, and when it comes to personnel costs, we have gained 10 percent."
 

Cons

"Their products work wonderfully during demos, but when we install them, they don't, and I end up following their manual only to find they forgot to mention something important."
"The product needs more plugins."
"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 stability is not great, especially when you start patching it a lot because things get broken."
"Its UI is probably a bit too confusing for that level of user, so it doesn't allow us to get the tool as widely distributed across the organization to non-technical users as much as we would like."
"In terms of improvements, while creating on a remote service, we face challenges related to limited memory, which calls for optimization."
"Since Hitachi took over, I don't feel that the documentation is as good within the solution."
"Communicating with the vendor is challenging, and this hinders its performance in free tool setups."
"The technical support does not reply in a timely manner. The support they have in place does not work very well."
 

Pricing and Cost Advice

Information not available
"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."
"The price of the regular version is not reasonable and it should be lower."
"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"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 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."
"You don't need the Enterprise Edition, you can go with the Community Edition. That way you can use it for free and, for free, it's a pretty good tool to use."
"There is a good open source option (Community Edition)​."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
886,976 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Construction Company
16%
Retailer
14%
Real Estate/Law Firm
7%
Transportation Company
7%
Financial Services Firm
15%
Educational Organization
9%
Government
7%
Construction 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

What is your experience regarding pricing and costs for ibi DataMigrator?
I don't have details about the pricing or licensing of ibi DataMigrator. I stay away from money matters; the last time I bought something was 35 years ago while trying to convince people it was wor...
What needs improvement with ibi DataMigrator?
I would assess the tool's error handling and logging features as part of it involves having a sampling thing. Depending on the definition of who's doing this, I used to work at a university where w...
What is your primary use case for ibi DataMigrator?
That's just it with the main use case for us more recently. We have it, we're licensed for it. We can make sure it works, but we don't really use ibi DataMigrator. ibi DataMigrator is an Extract, T...
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

iWay DataMigrator, Information Builders DataMigrator
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

Estonia Police Department
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Informatica, Microsoft, Qlik and others in Data Integration. Updated: March 2026.
886,976 professionals have used our research since 2012.