Pentaho Data Integration and Analytics vs WSO2 Enterprise Integrator comparison

Pentaho Data Integration and Analytics vs. WSO2 Enterprise Integrator

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

Pentaho Data Integration an...

Ranking in Data Integration

18th

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

WSO2 Enterprise Integrator

Ranking in Data Integration

32nd

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Enterprise Service Bus (ESB) (7th)

Mindshare comparison

As of October 2025, in the Data Integration category, the mindshare of Pentaho Data Integration and Analytics is 1.7%, up from 1.1% compared to the previous year. The mindshare of WSO2 Enterprise Integrator is 0.8%, up from 0.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration Market Share Distribution
Product	Market Share (%)
Pentaho Data Integration and Analytics	1.7%
WSO2 Enterprise Integrator	0.8%
Other	97.5%

Data Integration

Featured Reviews

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

Ritesh_Shah

Senior Solution Architect at Hewlett Packard Enterprise

Decreases the development timeframe and costs

The main issue with the product is pricing. It uses core-based pricing for WSO2 Enterprise Integrator and API Manager. It would be best if you had APIM by default. It provides many connectors for easy integration with third-party systems. Often, customers decide to develop using open-source tools like Spring Boot if there aren't many connectors required to avoid increasing costs. They'll develop this way and then deploy using APIM, the bare minimum needed. It is mainly required for very complicated setups with many connectors. In the implementations I've seen, people often used open-source tools because there weren't many third-party systems involved—just their organization's own systems. From WSO2 Enterprise Integrator, I expect them to bring up more and more connectors in the future. That's the main expectation. Having more connectors in various areas will help us when discussing new requirements. I don't have any specific use case right now, so I can't name a particular connector. But, as new technologies emerge, the relevant connectors should be there for those. WSO2 Enterprise Integrator mainly helps with the integration part, which can be simplified only if you have relevant connectors for whatever you're doing.

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

"Provides a good open source option."

"The abstraction is quite good."

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

"The amount of data that it loads and processes is good."

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

"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."

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

"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."

More Pentaho Data Integration and Analytics pros

"The learning curve for this solution is very good."

"Currently, I find the configuration part quite valuable, where you can easily configure things."

"It was mostly easy to set up the product."

"The productivity is the most valuable feature. It is very easy to write remediations."

"I like the user-friendly system and development of the service-oriented architecture."

"The solution basically conforms to our standards."

"The drag-and-drop features for connectors are very valuable."

"WSO2's analytics capability is good, considering the ELC support they provide."

More WSO2 Enterprise Integrator pros

Cons

"While Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle."

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

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

"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."

"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."

"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."

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

More Pentaho Data Integration and Analytics cons

"The integration capabilities need to be improved."

"You cannot include the validation of XPath."

"The product's price is an area of concern where improvements are required."

"The server is very specific and it is very difficult to get experience with it."

"The main issue with the product is pricing. It uses core-based pricing for WSO2 Enterprise Integrator and API Manager. It would be best if you had APIM by default. It provides many connectors for easy integration with third-party systems."

"The setup can be difficult for those not familiar with the solution."

"The administration side is complex and could use significant improvements to enhance the solution's functionality."

"One of the reasons that we are looking for a replacement is their way of defining integration. The language of the XML structures that I use to describe the integrations are not that standard, and it's not easy to find people who are familiar with this approach."

More WSO2 Enterprise Integrator cons

Pricing and Cost Advice

"There is a good open source option (Community Edition)."

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

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

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

"The cost of these types of solutions are expensive. So, we really appreciate what we get for our money. Though, we don't think of the solution as a top-of-the-line solution or anything like that."

"There was a cost analysis done and Pentaho did favorably in terms of cost."

More Pentaho Data Integration and Analytics pricing and cost advice

"The open-source, unsupported version is available free of charge."

"The pricing of WSO2 Enterprise Integrator for enterprise subscriptions can be considered expensive, especially from the perspective of someone who prefers open-source software."

"I rate the product price a six on a scale of one to ten, where one is low price and ten is high price."

"The cost is better than IBM Cloud Pak."

"The solution costs about 20,000 or 30,000 euros per year, per instance."

"It is a low-cost solution."

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration 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

18%

Computer Software Company

11%

Government

Manufacturing Company

Financial Services Firm

15%

Computer Software Company

15%

Comms Service Provider

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	17
Midsize Enterprise	16
Large Enterprise	25

By reviewers
Company Size	Count
Small Business	8
Midsize Enterprise	2
Large Enterprise	11

Questions from the Community

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

What do you like most about WSO2 Enterprise Integrator?

WSO2's analytics capability is good, considering the ELC support they provide.

What is your experience regarding pricing and costs for WSO2 Enterprise Integrator?

The product has reasonable and competitive pricing for enterprise customers. It is expensive for small businesses especially. They are using the open-source solution, and they find it expensive sin...

What needs improvement with WSO2 Enterprise Integrator?

Something that could be improved in WSO2 Enterprise Integrator is that the problem is not a lack of capability or functionalities. The problem is that it is a very complex environment. To put your ...

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

Comparisons

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

Oracle Service Bus vs WSO2 Enterprise Integrator

Compared 14% of the time

IBM Integration Bus vs WSO2 Enterprise Integrator

Compared 11% of the time

Spring Cloud Data Flow vs WSO2 Enterprise Integrator

Compared 8% of the time

webMethods.io vs WSO2 Enterprise Integrator

Compared 8% of the time

Red Hat Fuse vs WSO2 Enterprise Integrator

Compared 7% of the time

More WSO2 Enterprise Integrator Competitors

Product Reports

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

WSO2 Enterprise Integrator

Download WSO2 Enterprise Integrator product report

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

No data available

Overview

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

WSO2 Enterprise Integrator, core to the WSO2 Integration Agile Platform, is an open source Integration product for cloud native and container-native projects. It enables enterprise integration experts to build, scale, and secure sophisticated integration solutions to achieve digital agility. Unlike other integration products, WSO2 Enterprise Integrator already contains integration runtimes, message brokering, business process modeling, analytics and visual tooling capabilities.

WSO2

Sample Customers

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

West

Pentaho Data Integration and Analytics vs. WSO2 Enterprise Integrator