Pentaho Data Integration and Analytics vs Upsolver comparison

Hitachi Vantara and Upsolver are both solutions in the Data Integration category. Hitachi Vantara is ranked #18 with an average rating of 7.7, while Upsolver is ranked #40 with an average rating of 8.5. Hitachi Vantara holds a 1.7% mindshare in DI, compared to Upsolver’s 0.4% mindshare. Additionally, 94% of Hitachi Vantara users are willing to recommend the solution, compared to 100% of Upsolver users who would recommend it.

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

2,447 Views
1,884 Comparison Views

94% willing to recommend

Upsolver

Read 2 Upsolver reviews

369 Views
284 Comparison Views

100% willing to recommend

Pentaho Data Integration an...

Upsolver

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Pentaho Data Integration and Analytics and Upsolver based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Pentaho Data Integration and Analytics vs. Upsolver Report (Updated: September 2025).

Buyer's Guide

Pentaho Data Integration and Analytics vs. Upsolver

September 2025

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

Upsolver

Ranking in Data Integration

40th

Average Rating

8.6

Reviews Sentiment

7.6

Number of Reviews

Ranking in other categories

Streaming Analytics (20th)

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 Upsolver is 0.4%, up from 0.1% 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%
Upsolver	0.4%
Other	97.9%

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

"I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."

"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."

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

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

"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."

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

"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."

"Data transformation within Pentaho is a nice feature that they have and that I value."

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

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

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

Cons

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

"One thing that I don't like, just a little, is the backward compatibility."

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

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

"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."

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

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

"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."

More Pentaho Data Integration and Analytics cons

"There is room for improvement in query tuning."

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

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

Pricing and Cost Advice

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

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

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

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

"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

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

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

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

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

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

No data available

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

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

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

See all answers

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

See all answers

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

See all answers

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.

See all answers

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

See all answers

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

See all answers

Comparisons

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

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

Databricks vs Upsolver

Compared 59% of the time

Rivery vs Upsolver

Compared 41% of the time

More Upsolver Competitors

Product Reports

Buyer's Guide

Pentaho Data Integration and Analytics

September 2025

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Buyer's Guide

Data Integration

September 2025

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

Buyer's Guide

Pentaho Data Integration and Analytics vs. Upsolver

September 2025

Free Report: Pentaho Data Integration and Analytics vs. Upsolver

Find out what your peers are saying about Pentaho Data Integration and Analytics vs. Upsolver and other solutions. Updated: September 2025.

DOWNLOAD NOW

869,760 professionals have used our research since 2012.

See our Pentaho Data Integration and Analytics vs. Upsolver report.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.