Pentaho Data Integration and Analytics vs SAP Data Services comparison

Hitachi Vantara and SAP are both solutions in the Data Integration category. Hitachi Vantara is ranked #30 with an average rating of 7.8, while SAP is ranked #10 with an average rating of 8.2. Hitachi Vantara holds a 1.4% mindshare in DI, compared to SAP’s 2.9% mindshare. Additionally, 94% of Hitachi Vantara users are willing to recommend the solution, compared to 85% of SAP users who would recommend it.

Pentaho Data Integration an...

Read 51 Pentaho Data Integration and Analytics reviews

2,569 Views
1,095 Comparison Views

94% willing to recommend

SAP Data Services

Read 48 SAP Data Services reviews

5,358 Views
4,306 Comparison Views

85% willing to recommend

Pentaho Data Integration an...

SAP Data Services

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Pentaho Data Integration and Analytics and SAP Data Services 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. SAP Data Services Report (Updated: November 2024).

Buyer's Guide

Pentaho Data Integration and Analytics vs. SAP Data Services

November 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

Pentaho Data Integration an...

Ranking in Data Integration

30th

Average Rating

8.0

Reviews Sentiment

5.8

Number of Reviews

Ranking in other categories

No ranking in other categories

SAP Data Services

Ranking in Data Integration

10th

Average Rating

8.0

Number of Reviews

Ranking in other categories

Data Quality (2nd)

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Pentaho Data Integration and Analytics is 1.4%, up from 0.5% compared to the previous year. The mindshare of SAP Data Services is 2.9%, down from 3.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Ryan Ferdon

Senior Data Engineer at Burgiss

Low-code makes development faster than with Python, but there were caching issues

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. It was kind of buggy sometimes. And when we ran the flow, it didn't go from a perceived start to end, node by node. Everything kicked off at once. That meant there were times when it would get ahead of itself and a job would fail. That was not because the job was wrong, but because Pentaho decided to go at everything at once, and something would process before it was supposed to. There were nodes you could add to make sure that, before this node kicks off, all these others have processed, but it was a bit tedious. There were also caching issues, and we had to write code to clear the cache every time we opened the program, because the cache would fill up and it wouldn't run. I don't know how hard that would be for them to fix, or if it was fixed in version 10. Also, the UI is a bit outdated, but I'm more of a fan of function over how something looks. One other thing that would have helped with Pentaho was documentation and support on the internet: how to do things, how to set up. I think there are some sites on how to install it, and Pentaho does have a help repository, but it wasn't always the most useful.

Read full review

RambabuMandala

Software Development Senior Advisor at Dell EMC

Responsive support, scalable, and beneficial integration

The BA reporting tools, such as Data Services, and ETL tool in SAP Data Services are the most valuable. When we had in-memory requirements, we used HANA. HANA is most preferably for most the customers for in-memory. SAP is the first company that created the in-memory concept. There are a lot of SAP applications and they have good integration with SAP packages. In the next release, they should be more advanced cloud functionalities and web services. More integration with other applications including SAPs and other applications. They should not switch to a complete solution but provide better integration with other applications.

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

"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 is easy to use, install, and start working with."

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

"This solution allows us to create pipelines using a minimal amount of custom coding."

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

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

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

More Pentaho Data Integration and Analytics pros

"The user interface is ok."

"You can always manipulate a lot of things as long as you have the skill level."

"The API tool in this product is very valuable; it is very easy to onboard and use."

"The initial setup is not complex."

"The HANA database, which is very fast, is a valuable feature."

"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."

"I like how SAP Data Services links reporting and data integration. That's what's most interesting. You also have the opportunity to leverage the power of the Data Services server."

"The most valuable feature of SAP Data Services is the integration with data sources."

More SAP Data Services pros

Cons

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

"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."

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

"The product needs more plugins."

"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."

"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."

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

"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."

More Pentaho Data Integration and Analytics cons

"The migration of the solution between different environments is quite complex."

"In the future, Data Services should offer a cloud version."

"SAP Data Services should be made a web-based solution."

"The solution could improve the overall features. There is a lot that can be done in the solution, therefor there are areas where it can improve. Additionally, there is a need to make it easier for one to create connections to other non-SAP systems. The flexibility to connect to other non-SAP systems is needed."

"Newer feature integration is lagging behind the company acquisitions and the product could do more to service a broader range of devices."

"Address validation in SAP Data Services is chargeable and should be made free."

"The execution engines and processing engines have shortcomings and need improvements."

"They could make it easier to work with web services."

More SAP Data Services cons

Pricing and Cost Advice

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

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

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

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

"There is a good open source option (Community Edition)."

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

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

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

More Pentaho Data Integration and Analytics pricing and cost advice

"At the entry level, if you're using it only for data integration, it is a little bit cheap. However, for large organizations it can be expensive. There are additional costs apart from the license."

"The enterprise version of SAP Data Services is free."

"Its pricing is as per the enterprise agreement and not a concern for us."

"Pricing is good, there is no problem."

"The price is very reasonable."

"The license price is expensive but medium to large-scale companies, should be able to afford it. Other solutions, such as Talend are easier to afford for smaller companies. Depending on the sources of the data where you are receiving your data you could be paying for more than one license."

"The product’s on-premise version is expensive for a medium-sized company."

"It's relatively expensive compared to other vendors, but it is competitive."

More SAP Data Services pricing and cost advice

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

816,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

23%

Computer Software Company

14%

Government

Comms Service Provider

Manufacturing Company

15%

Computer Software Company

13%

Financial Services Firm

Energy/Utilities Company

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

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

How do you evaluate the ratio of price to quality for SAP Data Services?

I believe the license for the product is fair, even though some competitors offer similar services at lower prices. The difference between the Edge edition and the next one up is significant in pr...

See all answers

Would you recommend SAP Data Services to complete beginners?

I think after some preparation, a beginner will be able to use SAP Data Services, however, if you are completely unprepared, you may have some issues. I think that in particular you will need a mo...

See all answers

How has SAP Data Services helped your organization?

SAP Data Services has helped our whole staff understand the data across various sources and systems within the company. Not everyone who works at my organization is an IT expert - most just have av...

See all answers

Comparisons

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

Compared 17% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 16% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 11% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 10% of the time

AWS Glue vs Pentaho Data Integration and Analytics

Compared 8% of the time

More Pentaho Data Integration and Analytics Competitors

Syniti Data Quality vs SAP Data Services

Compared 20% of the time

Azure Data Factory vs SAP Data Services

Compared 13% of the time

Informatica PowerCenter vs SAP Data Services

Compared 9% of the time

SAP Process Orchestration vs SAP Data Services

Compared 7% of the time

Palantir Foundry vs SAP Data Services

Compared 7% of the time

More SAP Data Services Competitors

Product Reports

Buyer's Guide

Pentaho Data Integration and Analytics

November 2024

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Buyer's Guide

SAP Data Services

October 2024

Download SAP Data Services product report

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

SAP BusinessObjects Data Services, SAP BusinessObjects Data Integrator, BusinessObjects Data Integrator

Learn More

Hitachi Vantara

SAP

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.

SAP Data Services is a top-ranking data integration and data quality tool. This is a product that aims to provide its users with effective access to their data in order to transform it and connect it to various business processes. SAP Data Services offers companies detailed data insights which improve decision-making and make company operations more effective.

Organizations can increase the value of their structured and unstructured data with the functionalities of this product regarding data integration, quality, and cleansing. Through various components such as:

Simplified maintenance
On-premises deployment
Data quality and integration
Intuitive user interfaces

the product transforms data into a ready-to-use resource for business insights.

Some of the key components of SAP Data Services include:

Universal data access
Native-text data processing
Intuitive user interfaces
Data quality dashboards
Simplified data governance
Scalability and high performance

Through these components, the product allows its clients to access and integrate data sources and targets with native connectors. Users can derive meaning from unstructured text data, match data to reduce duplicates, and see the impact of data quality issues. The tool also offers the option to enable parallel processing, bulk data loading, and grid computing for high-volume data loads.

SAP Data Services Features

The solution has different features for data integration, data quality, data profiling, and processing of text data. Using these features, clients can manage their company's data easily and achieve excellent results by optimizing it. Some of the product’s features include:

Data integration capabilities: The features regarding data integration provide a wide variety of opportunities. The product is available in 31 languages and connects to many data sources, providing its clients with access to their data anywhere at any time. It is also integrated with the SAP Business Suite applications, allowing users the full experience that the company has to offer. The tool is interconnected with SAP Data Hub, orchestrating data flows through the SAP Data Intelligence solution. Additionally, it supports a large number of third-party data sources, it is optimized for SAP HANA, and provides fine-tuned data replication and transformation through unique mechanisms.
Data quality capabilities: Clients can use a single interface to access designing, testing, debugging, editing, running, maintaining, and monitoring of data integration and data quality. It allows for the delivery of ready-to-use transformations and exposes hidden problems in users' data. With this feature, clients can build a single version of their data that is most efficient for them.
Data profiling capabilities: Companies that work with high-volume data can employ parallel processing, bulk data loading, and grid computing to be able to operate with the data more efficiently. This feature enables unlimited scalability and high availability by various automations. It also provides excellent security for the treated data through encryption and other services.
Processing of text data capabilities: This feature allows users to extract data from unstructured texts and understand it better. It works with 220 different file and text formats and 31 languages.

SAP Data Services Benefits

This solution offers various benefits to its clients regarding the efficient operation of their data. The key benefits of SAP Data Services include:

Broad access to data which can build a better perspective for companies of their information.
Improved decision-making and information management due to efficient data operations.
Ability to utilize various tools to help unify data on premises, in the cloud, or within big data.
The software provides efficient insight for reporting and data analytics.
The tool allows for easy integration with a large number of different databases.
The product provides the opportunity to seamlessly connect with other SAP solutions.
The solution simplifies extract, transform, and load (ETL) construction processes through intuitive graphic software.

Reviews from Real Users

According to Michael Lutz, senior data warehouse developer at Fox Chase Cancer Center, SAP Data Services is a powerful tool that does a lot.

An associate consultant at a consultancy says the tool is easy to use, simple to implement, and offers very good mapping capabilities.

Sample Customers

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

EMC Corporation, LivePerson, Eldorado, Mozzart, The VELUX Group, AOK Bundesverband, Hilti Group, Nissha Printing Company Ltd., Asian Paints, Aareal Bank Group, Migros Group

Buyer's Guide

Pentaho Data Integration and Analytics vs. SAP Data Services

November 2024

Free Report: Pentaho Data Integration and Analytics vs. SAP Data Services

Find out what your peers are saying about Pentaho Data Integration and Analytics vs. SAP Data Services and other solutions. Updated: November 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our Pentaho Data Integration and Analytics vs. SAP Data Services 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.