Try our new research platform with insights from 80,000+ expert users

Pentaho Data Integration and Analytics vs SAP Analytics Hub comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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
53
Ranking in other categories
No ranking in other categories
SAP Analytics Hub
Ranking in Data Integration
50th
Average Rating
7.2
Reviews Sentiment
6.4
Number of Reviews
7
Ranking in other categories
BI (Business Intelligence) Tools (32nd)
 

Mindshare comparison

As of August 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 SAP Analytics Hub is 0.2%, up from 0.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Aqeel UR Rehman - PeerSpot reviewer
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…
Hyunwook Kang - PeerSpot reviewer
Provides efficient data integration features, but the technical support services need improvement
We use the product for analytics across various business processes and sectors. It helps us analyze SAP ERP data The platform's main benefit is its integration with SAP ERP data. It’s effective for data integration and integrity. The platform could easily integrate with other ERP data solutions.…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"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."
"The product is user-friendly and intuitive"
"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."
"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."
"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."
"It's very simple compared to other products out there."
"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."
"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."
"This product provides good reports using a single pane of glass."
"For report scheduling, I always prefer SAP because it has the most powerful scheduling features, like sending reports to more than 1,000 customers per day. That option is not as good in Microsoft BI and in Tableau it only exists as an add-on option."
"SAP Analytics Hub offers a user-friendly interface with effortless configuration, seamless updates, and real-time availability of information. It avoids the complexities associated with batch processing, providing a smooth and efficient experience."
"The platform's main benefit is its integration with SAP ERP data. It’s effective for data integration and integrity."
"What I like best about this solution is that it is built into the SAP line, making it easier to integrate with other SAP products."
"Data consistency is also a notable feature; the system takes care of data consistency, so you don't need to handle it manually."
 

Cons

"Larger data jobs take more time to execute."
"If you develop it on MacBook, it'll be quite a hassle."
"Communicating with the vendor is challenging, and this hinders its performance in free tool setups."
"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..."
"​There is not a data quality or MDM solution in the Pentaho DI suite.​"
"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."
"I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking."
"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."
"Pricing and support are integrated into the system. However, the support process can be challenging, particularly when navigating the SAP support site, which lacks user-friendliness and ease of access."
"The interface can be simplified because it is not a user-friendly experience."
"The platform could easily integrate with other ERP data solutions. Additionally, it should be faster compared to competitors in the cloud space."
"Faster implementation of new functions for the new product is an area of improvement in SAP Analytics Hub."
"The technical support for Analytics Hub is limited and could be improved."
"The analytics part of SAP has not been that good up until now. They're still in the infant stage and development is still going on. SAP has some cloud analytics and they're trying to configure it in Lumira, but it's not that good at this point."
 

Pricing and Cost Advice

"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"
"I mostly used the open-source version. I didn't work with a license."
"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 primarily work on the Community Version, which is available to use free of charge."
"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."
"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."
"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."
"The pricing is reasonable."
"It is an expensive solution."
"They are pursuing a highly assertive approach to target businesses of all sizes within the industry."
"The product is expensive."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
865,484 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
Healthcare Company
11%
Manufacturing Company
11%
Financial Services Firm
9%
Energy/Utilities Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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 SAP Analytics Hub?
The product is expensive. The cost starts from $1,000,000 per year. Moreover, there are additional costs involved for customization.
What needs improvement with SAP Analytics Hub?
The platform could easily integrate with other ERP data solutions. Additionally, it should be faster compared to competitors in the cloud space.
What advice do you have for others considering SAP Analytics Hub?
I advise others to be aware of the total ownership cost of the product for the next three to five years. I rate it a seven out of ten.
 

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
No data available
 

Overview

 

Sample Customers

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
STIB-MIVB
Find out what your peers are saying about Pentaho Data Integration and Analytics vs. SAP Analytics Hub and other solutions. Updated: July 2025.
865,484 professionals have used our research since 2012.