Pentaho Data Integration and Analytics vs WSO2 Enterprise Integrator comparison

Pentaho Data Integration and Analytics vs. WSO2 Enterprise Integrator

Download the complete report

Helped 870,623 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

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

"The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."

"Provides a good open source option."

"This solution allows us to create pipelines using a minimal amount of custom coding."

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

"The solution offers features for data integration and migration. Pentaho Data Integration and Analytics allows the integration of multiple data sources into one. The product is user-friendly and intuitive to use for almost any business."

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

"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."

More Pentaho Data Integration and Analytics pros

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

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

"It's a consolidated product. It works and it does its job pretty well."

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

"The solution's customer service is good."

"The solution has two main parts: integration and transformation. It's very user-friendly and easy to understand for everyone."

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

"It's a very complete product. It allows us to network security and add more layers of security to the system."

More WSO2 Enterprise Integrator pros

Cons

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

"In terms of the flexibility to deploy in any environment, such as on-premise or in the cloud, we can do the cloud deployment only through virtual machines. We might also be able to work on different environments through Docker or Kubernetes, but we don't have an Azure app or an AWS app for easy deployment to the cloud. We can only do it through virtual machines, which is a problem, but we can manage it. We also work with Databricks because it works with Spark. We can work with clustered servers, and we can easily do the deployment in the cloud. With a right-click, we can deploy Databricks through the app on AWS or Azure cloud."

"The reporting definitely needs improvement. There are a lot of general, basic features that it doesn't have. A simple feature you would expect a reporting tool to have is the ability to search the repository for a report. It doesn't even have that capability. That's been a feature that we've been asking for since the beginning and it hasn't been implemented yet."

"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."

"The product needs more plugins."

"There is not a data quality or MDM solution in the Pentaho DI suite."

"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."

"I would like to see more improvements with AS400 DB2."

More Pentaho Data Integration and Analytics cons

"The micro integrator should be improved. There is room for enhancement considering alternative integration components."

"You cannot include the validation of XPath."

"WSO2 libraries are not mature enough. For example, if you want to integrate with Kafka using its Kafka library, it often has many bugs."

"I would like to see them bring back a feature, from earlier versions, that was very useful in debugging and finding issues."

"They should introduce better pricing for small companies."

"The integration capabilities need to be improved."

"They should release upgrades more frequently."

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

More WSO2 Enterprise Integrator cons

Pricing and Cost Advice

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

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

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

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

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

"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 price of the regular version is not reasonable and it should be lower."

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

More Pentaho Data Integration and Analytics pricing and cost advice

"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 open-source, unsupported version is available free of charge."

"It is a low-cost solution."

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

"The cost is better than IBM Cloud Pak."

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

870,623 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

18%

Computer Software Company

12%

Government

Manufacturing Company

Computer Software Company

15%

Financial Services Firm

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 11% 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 13% 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

Red Hat Fuse vs WSO2 Enterprise Integrator

Compared 8% of the time

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