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

FME 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

FME
Ranking in Data Integration
31st
Average Rating
8.6
Reviews Sentiment
6.5
Number of Reviews
7
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 FME is 1.1%, down from 1.8% 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%
FME1.1%
Other97.2%
Data Integration
 

Featured Reviews

Gert Booysen - PeerSpot reviewer
Software Solutions Leader at GE Vernova
Extensive format support and reliable integration enhance data management while new pricing model requires reassessment
I haven't had any input or requirements from any customers that are not currently covered, so I don't have any additional needs that were identified or raised to me. Regarding pricing, with the model changes that they've implemented a while back, it actually made it more expensive to use, especially on the server side. They changed the licensing model, and that made customers think it is overpriced. Some customers were actually looking at alternatives. Pricing with the model changes was perceived negatively. I work primarily with enterprise customers, Vodacom, Eskom, so it's tier-one customers. For small customers, this solution is a bit too expensive. They don't really use it and just do direct integration on smaller implementations. This is basically used by tier-one customers. FME is still able to save time and money for clients. It's still a good investment. Regarding similar products to FME, GE developed a product called Data Fabric. That is a real-time operational integration platform, Data Fabric Network Connect, which is a GE Grid OS product. It is actually more expensive than FME, but the purpose is different as it's operational. The vendor in this case is GE, and it's a company that we bought that used to be called Greenbird. In current use scenarios, FME is still leading compared to Data Fabric. The GE product has a different application.
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

"From my reseller perspective, the best features in FME are the ease of operation and the fact that it works."
"We make minor subtle changes to the workbenches to improve it. We can share the workbenches. We don't have to use GitHub or anything else."
"FME is spatially aware and understands how to deal with the conversion of spatial objects and their attributes."
"The most valuable feature of FME is the graphical user interface."
"It has a very friendly user interface. You don't need to use a lot of code. For us that's the most important aspect about it. Also, it has a lot of connectors and few forms. It has a strong facial aspect. It can do a lot of facial analysis."
"It has standard plug-ins available for different data sources."
"All spatial features are unrivaled, and the possibility to execute them based on a scheduled trigger, manual, e-mail, Websocket, tweet, file/directory change or virtually any trigger is most valuable."
"The most valuable feature of FME is the graphical user interface. There is nothing better. It is very easy to debug because you can see all steps where there are failures. Overall the software is easy to optimize a process."
"With this solution, instead of it taking a week, it was reduced to an afternoon, or about three hours."
"It has made a world of difference."
"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."
"I would say this is the best ETL tool in the market, considering this is open source and ease to use, very nice GUI."
"You can get ETL, reporting, analysis, and analytics in a single shop."
"You can get ETL, reporting, analysis, and analytics in a single shop."
"It allows for rapid prototyping of a wide array of ETL workloads."
"Before we used Pentaho, our processes were in Microsoft Excel and the updates from databases had to be done manually, but now all our routines are done automatically and we have more time to do other jobs, saving us four or five hours daily."
 

Cons

"The one thing that always appears in the community is the ability to make really easy loops to loop through data efficiently. That needs to be added at some point."
"We are looking at the possibility of using Glue instead of FME, using the native AWS product."
"FME's price needs improvement for the African market."
"FME can improve the geographical transformation. I've had some problems with the geographical transformations, but it's probably mostly because I'm not the most skilled geographer in-house."
"FME is a great tool, but I don't know if we can scale it up since the prices are high and we would need to convince the decision makers to provide more budget."
"FME can improve the geographical transformation. I've had some problems with the geographical transformations, but it's probably mostly because I'm not the most skilled geographer in-house. The solution requires some in-depth knowledge to perform some functions."
"Improvements could be made to mapping presentations."
"To get a higher rating, it would have to improve the price and the associated scalability. These are the main issues."
"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."
"The initial version we were on was v3.2 and we had multiple issues, but currently don't find any issues as a blocker."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"They could improve the logging generator. Sometimes the error description is so generic that it is not possible to detect the problem."
"For managing very large volumes of data, Pentaho Data Integration and Analytics is not the best tool, but it is in a good position to handle millions of records."
"Pentaho Dashboard Designer - needs an improvement on the various features of the Dashboards, since there are CTools available and which help to fulfil the gaps, but it needs developers involvement."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"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."
 

Pricing and Cost Advice

"FME Server used to cost £10,000; now it can cost over £100,000."
"We used the standard licensing for our use of FME. The cost was approximately €15,000 annually. We always welcome less expensive solutions, if the solution could be less expensive it would be helpful."
"The product's price is reasonable."
"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."
"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."
"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."
"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 mostly used the open-source version. I didn't work with a license."
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."
"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
893,221 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Government
29%
Energy/Utilities Company
13%
Construction Company
7%
Comms Service Provider
5%
Financial Services Firm
15%
Educational Organization
8%
Government
7%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business2
Midsize Enterprise1
Large Enterprise4
By reviewers
Company SizeCount
Small Business18
Midsize Enterprise17
Large Enterprise31
 

Questions from the Community

What needs improvement with FME?
I haven't had any input or requirements from any customers that are not currently covered, so I don't have any additional needs that were identified or raised to me. Regarding pricing, with the mod...
What is your primary use case for FME?
The use cases for FME are mainly integration to the GE Smallworld product. GE Smallworld is a GE product, and we are using it to integrate with other third-party products into GE Smallworld and ADM...
What advice do you have for others considering FME?
The overall rating for FME is eight out of ten, and I prefer the feedback to be anonymous. My job title is Senior Solutions Architect.
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

No data available
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

Shell, US Department of Commerce, PG&E, BC Hydro, City of Vancouver, Enel, Iowa DoT, San Antonio Water System
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about FME vs. Pentaho Data Integration and Analytics and other solutions. Updated: April 2026.
893,221 professionals have used our research since 2012.