Pentaho Data Integration and Analytics vs WSO2 Enterprise Integrator comparison

Pentaho Data Integration and Analytics vs. WSO2 Enterprise Integrator

Download the complete report

Helped 915,341 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

28th

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 2026, in the Data Integration category, the mindshare of Pentaho Data Integration and Analytics is 1.8%, up from 1.6% compared to the previous year. The mindshare of WSO2 Enterprise Integrator is 1.0%, up from 0.8% 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.8%
WSO2 Enterprise Integrator	1.0%
Other	97.2%

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

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

"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."

"We've seen a 50 percent reduction in our ETL development time using the free version of Pentaho, saving about 1,000 euros per week and at least 50,000 euros annually."

"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."

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

"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."

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

"Anyone thinking about an ETL product, if they want high productivity on data cleaning and data movement, Pentaho Data Integration, in my opinion, is the best tool."

More Pentaho Data Integration and Analytics pros

"The installation process is easy."

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

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

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

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

"The solution basically conforms to our standards."

"The solution's customer service is good."

"The connectors have been the most impactful features for handling integrations. I can use these connectors when I need specific connectivity with a third party, like a core banking system in BFSI. I don't need to do all the development. I take the specific connector, put in the IP address and password, and it takes care of everything."

More WSO2 Enterprise Integrator pros

Cons

"I would like to see more improvements with AS400 DB2. I journalled the tables/instance and the data migration is too slow if I compare it with other databases."

"The stability is not great, especially when you start patching it a lot because things get broken."

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

"I was not happy with the Pentaho Report Designer because of the way it was set up."

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

"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."

"The one annoyance that troubled us a lot was the fact that every step in a transformation that needed data, created its own data connection."

"Its performance can be improved so it will work better with Big Data. Also, sometimes it can be very buggy which keeps away some potential users."

More Pentaho Data Integration and Analytics cons

"For simpler tasks or simpler use cases, we avoid using WSO2 Enterprise Integrator because it is quite complex."

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

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

"The configuration of the product is not an easy task for everyone."

"There are a lot of security settings that when you apply you have to re-apply again every time you modify a setting. It is something that really needs to be enhanced."

"You cannot include the validation of XPath."

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

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

More WSO2 Enterprise Integrator cons

Pricing and Cost Advice

"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."

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

"I primarily work on the Community Version, which is available to use free of charge."

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

"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."

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

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

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

More Pentaho Data Integration and Analytics pricing and cost advice

"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 pricing of WSO2 Enterprise Integrator for enterprise subscriptions can be considered expensive, especially from the perspective of someone who prefers open-source software."

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

"It is a low-cost solution."

"The cost is better than IBM Cloud Pak."

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

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

915,341 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

12%

Outsourcing Company

11%

Construction Company

Educational Organization

Outsourcing Company

14%

Financial Services Firm

10%

Construction Company

Comms Service Provider

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

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Comparisons

Compared 8% of the time

Airbyte Cloud vs Pentaho Data Integration and Analytics

Compared 8% of the time

SSIS 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

StreamSets vs Pentaho Data Integration and Analytics

Compared 5% of the time

More Pentaho Data Integration and Analytics Competitors

Mule ESB vs WSO2 Enterprise Integrator

Compared 7% of the time

Oracle Data Integrator (ODI) vs WSO2 Enterprise Integrator

Compared 6% of the time

MuleSoft Anypoint Platform vs WSO2 Enterprise Integrator

Compared 6% of the time

IBM Integration Bus vs WSO2 Enterprise Integrator

Compared 6% of the time

Oracle Service Bus vs WSO2 Enterprise Integrator

Compared 4% 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