Pentaho Data Integration and Analytics vs WSO2 Enterprise Integrator comparison

Pentaho Data Integration and Analytics vs. WSO2 Enterprise Integrator

Download the complete report

Helped 902,988 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

9th

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

WSO2 Enterprise Integrator

Ranking in Data Integration

29th

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Enterprise Service Bus (ESB) (6th)

Mindshare comparison

As of July 2026, in the Data Integration category, the mindshare of Pentaho Data Integration and Analytics is 1.7%, down from 1.7% compared to the previous year. The mindshare of WSO2 Enterprise Integrator is 1.0%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration Mindshare Distribution
Product	Mindshare (%)
Pentaho Data Integration and Analytics	1.7%
WSO2 Enterprise Integrator	1.0%
Other	97.3%

Data Integration

Featured Reviews

Michelle Lawson

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.

Read full review

Andrea Cuccarini

Technical director at Cremete

Effective data transformation and integration in complex environments with high functionality

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 hand on this environment is a very demanding task. This is the real problem. The problem is not about the product, but about the complexity to manage, to configure, to decide what to do. I have some experience using SAP R/3. It seems to me something similar. When you have to configure a situation with a client, especially for a client not in an industrial sector, but in a service sector, it is quite usual that you are in trouble for some reason. This is always the story that I found in the implementations I have done. Maybe there are only three or four big problems, in some other cases there are more than that, but this is the situation usually. For WSO2 Enterprise Integrator, not the same, but I must say it is quite often there is a need to put together some pieces and make it work in a coordinated way.

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

"It's very simple compared to other products out there."

"The tool is excellent, and almost everyone can use it."

"Pentaho Data Integration and Analytics has positively impacted my organization because it meant we didn't have to write a lot of custom API back-end processing logic; it did the majority of that heavy lifting for us."

"The solution is easy to set up, very intuitive, clear to understand and easy to maintain."

"Using Lumada compared to using SQL manually, ETL development time is half the time it took using a basic manual transformation."

"Easy to use, support for all databases (jdbc and odbc connection), xls, csv, files, txt, SAS, R."

"Overall it is an awesome tool."

"Previously, I had three people to collect all the data and integrate all Excel spreadsheets, and it took them a day or two, but now I can do this work in about 15 minutes."

More Pentaho Data Integration and Analytics pros

"The stability is excellent."

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

"From the capabilities and functional possibility and anything else technical, it is a very well-done product, I have to say."

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

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

"While I am still exploring the solution, I've so far been pretty satisfied with it."

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

"It has improved our time management because development is quicker."

More WSO2 Enterprise Integrator pros

Cons

"Should provide additional control for the data warehouse"

"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."

"The only complaint that I have with Pentaho has been with scaling."

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

"If you're working with a larger data set, I'm not so sure it would be the best solution; the larger things got the slower it was and it was kind of buggy sometimes."

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

"It is difficult to process huge amounts of data."

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

More Pentaho Data Integration and Analytics cons

"You cannot include the validation of XPath."

"If I have to buy software, then it becomes expensive for me."

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

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

"I would like to see better documentation for the open-source version."

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

"In my opinion, the administration model and interface, of Carbon, are lacking in terms of its features and user experience."

"They should release upgrades more frequently."

More WSO2 Enterprise Integrator cons

Pricing and Cost Advice

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

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

"I mostly used the open-source version. I didn't work with a license."

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

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

"The price of the regular version is not reasonable and it should be lower."

"I believe the pricing of the solution is more affordable than the competitors"

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

"It is a low-cost solution."

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

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

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

902,988 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Educational Organization

Construction Company

Manufacturing Company

Financial Services Firm

11%

Comms Service Provider

Construction Company

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	17
Large Enterprise	32

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 needs improvement with WSO2 Enterprise Integrator?

What is your primary use case for WSO2 Enterprise Integrator?

A typical use case for WSO2 Enterprise Integrator is when I am in an interoperability environment with healthcare facilities and I have to put together a lot of applications that share some HL7 mes...

What advice do you have for others considering WSO2 Enterprise Integrator?

For simpler tasks or simpler use cases, we avoid using WSO2 Enterprise Integrator because it is quite complex. So it is easier to manage some more simple solutions than that. WSO2 Enterprise Integr...

Airbyte Cloud vs Pentaho Data Integration and Analytics

Comparisons

Compared 11% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 7% of the time

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

Compared 7% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 7% of the time

StreamSets vs Pentaho Data Integration and Analytics

Compared 5% of the time

More Pentaho Data Integration and Analytics Competitors

MuleSoft Anypoint Platform vs WSO2 Enterprise Integrator

Compared 7% of the time

IBM Integration Bus vs WSO2 Enterprise Integrator

Compared 7% of the time

Mule ESB vs WSO2 Enterprise Integrator

Compared 7% of the time

Oracle Data Integrator (ODI) vs WSO2 Enterprise Integrator

Compared 5% of the time

Boomi iPaaS vs WSO2 Enterprise Integrator

Compared 5% 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 and Analytics offers an intuitive platform for data workflows, enabling users to easily manage ETL processes across diverse data formats, ensuring seamless automation and development.

With its drag-and-drop interface, Pentaho allows for efficient ETL workflows without extensive coding. It supports a multitude of data formats and sources such as SQL, NoSQL, Hadoop, CSV, and JSON. Advanced features like metadata injection and API integration enable seamless automation. However, improvements in big data performance, better cloud service integration, and enhanced real-time processing capabilities can enhance user experience. Additional connectors and improved documentation are sought after by many. Providing support for more programming languages and optimizing memory usage also presents opportunities for enhancement.

What are the key features of Pentaho Data Integration and Analytics?

Drag-and-Drop Interface: Simplifies building workflows without coding.
Broad Data Support: Accommodates SQL, NoSQL, Hadoop, CSV, and JSON.
Advanced Automation: Leverages metadata injection and API integration.
Cost-Effectiveness: Offers value with comprehensive big data support.

What benefits should be evaluated in Pentaho reviews?

Versatility: Supports both on-premises and cloud solutions.
Data Integration: Facilitates seamless connection of disparate data sources.
Transparency: Enhances data management and reporting.
Scalability: Adapts to the growing data needs of organizations.

Pentaho is employed across finance, healthcare, and retail industries for ETL processes. It's instrumental in integrating data from ERP, SAP systems, Excel, and APIs to develop comprehensive reports and data models. Companies rely on its capabilities for both on-premises and cloud deployments, improving data transparency and management.

Hitachi Vantara

WSO2 Enterprise Integrator is known for its robust integration and transformation capabilities with a user-friendly interface. It provides comprehensive API management, format conversion, and integration standardization, ensuring efficient and scalable operations.

WSO2 Enterprise Integrator is a versatile platform valued for integrating legacy systems, orchestrating APIs, and transforming data formats such as XML to JSON. Its open-source nature offers flexibility in adapting to diverse system requirements, making it a preferable choice in sectors like finance and healthcare. It helps expose internal services to external entities, supports microservices development, and fits well in enterprise service bus scenarios. Stability, performance, and cost-effectiveness are paramount, though customization and complex administration pose challenges. Improvements in documentation, integration studio, and support quality can enhance its service.

What are the key features?

User-Friendly GUI: Simplifies configuration and streamlines development tasks.
Integration and Transformation: Supports extensive adapters and connectors.
API Management: Facilitates format conversion and integration standardization.
Scalability and Performance: Ensures high stability and efficient operations.
Open-Source Flexibility: Allows seamless adaptation with diverse systems.

What benefits or ROI should users evaluate?

Cost-Effectiveness: Offers a competitive pricing model despite high initial costs.
Stability and Reliability: Delivers consistent performance suitable for mission-critical projects.
Flexibility: Accommodates complex requirements efficiently.
Scalable Solutions: Adapts to growing business needs without compromising performance.
Efficient Development: Speeds up tasks, improving developer productivity.

WSO2 Enterprise Integrator is applied across different industry scenarios, primarily in integration projects connecting legacy and external platforms. In finance and banking, it supports core integration initiatives, while healthcare uses it for interoperability. Organizations benefit from its deployment in both on-premise and industry-specific environments, where it aids in building and managing microservices and APIs effectively.

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