Pentaho Data Integration and Analytics vs Upsolver comparison

Pentaho Data Integration and Analytics vs. Upsolver

Download the complete report

Helped 860,168 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

19th

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

Upsolver

Ranking in Data Integration

38th

Average Rating

8.6

Reviews Sentiment

7.6

Number of Reviews

Ranking in other categories

Streaming Analytics (18th)

Mindshare comparison

As of July 2025, in the Data Integration category, the mindshare of Pentaho Data Integration and Analytics is 1.8%, up from 0.8% compared to the previous year. The mindshare of Upsolver is 0.2%, up from 0.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.

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

Snehasish Das

Technology Leader at eTCaaS

Allows for data to be moved across platforms and different data technologies

The most prominent feature of Upsolver is its function as an ETL tool, allowing data to be moved across platforms and different data technologies. Upsolver does this in a quick time, unlike traditional processes which are time-consuming. Additionally, it offers scalability for large volumes of data, with performance and ease of cloud-native integration.

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

"It's my understanding that the product can scale."

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

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

"The product is user-friendly and intuitive"

"The solution has a free to use community version."

"The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."

"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."

More Pentaho Data Integration and Analytics pros

"The most prominent feature of Upsolver is its function as an ETL tool, allowing data to be moved across platforms and different data technologies."

"Customer service is excellent, and I would rate it between eight point five to nine out of ten."

"It was easy to use and set up, with a nearly no-code interface that relied mostly on drag-and-drop functionality."

Cons

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

"I would like to see improvements made for real-time data processing."

"Larger data jobs take more time to execute."

"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 product needs more plugins."

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

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

"If you develop it on MacBook, it'll be quite a hassle."

More Pentaho Data Integration and Analytics cons

"There is room for improvement in query tuning."

"On the stability side, I would rate it seven out of ten. Using multiple cloud providers and data engineering technologies creates complexity, and managing different plugins is not always easy, but they are working on it."

"Upsolver excels in ETL and data aggregation, while ThoughtSpot is strong in natural language processing for querying datasets. Combining these tools can be very effective: Upsolver handles aggregation and ETL, and ThoughtSpot allows for natural language queries. There’s potential for highlighting these integrations in the future."

Pricing and Cost Advice

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

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

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

"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 mostly used the open-source version. I didn't work with a license."

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

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

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

More Pentaho Data Integration and Analytics pricing and cost advice

"Upsolver is affordable at approximately $225 per terabyte per year."

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

860,168 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Computer Software Company

14%

Government

Manufacturing Company

No data available

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

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 is your experience regarding pricing and costs for Upsolver?

Upsolver is affordable at approximately $225 per terabyte per year. Compared to what I know from others, it's cheaper than many other products.

What needs improvement with Upsolver?

There is room for improvement in query tuning. Upsolver could do a more in-depth analysis in employing machine power, such as CPU and memory, to enhance query performance. Furthermore, allocating C...

What is your primary use case for Upsolver?

I am working as a consultant and currently have my own consultancy services. I provide services to companies that are data-heavy and looking for data engineering solutions for their business needs....

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

Comparisons

Compared 16% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 11% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 10% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 9% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 8% of the time

More Pentaho Data Integration and Analytics Competitors

Databricks vs Upsolver

Compared 100% of the time

More Upsolver Competitors

Product Reports

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

Data Integration

Download Upsolver 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

Upsolver's mission is to turn engineering-intensive data lakes into easy-to-use repositories that serve 50X more data professionals compared to the status-quo today. Upsolver cuts 95% from the tedious process of preparing event data for analytics and machine learning, using a visual SQL-based interface, a cloud-native data platform and deep technology for stream-processing, indexing and eventually-consistent file systems.

Upsolver

Sample Customers

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

Information Not Available

Pentaho Data Integration and Analytics vs. Upsolver