Pentaho Data Integration and Analytics vs SAP Process Orchestration comparison

Pentaho Data Integration and Analytics vs. SAP Process Orchestration

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

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (18th)

SAP Process Orchestration

Average Rating

8.2

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Business-to-Business Middleware (2nd)

Mindshare comparison

Pentaho Data Integration and Analytics and SAP Process Orchestration aren’t in the same category and serve different purposes. Pentaho Data Integration and Analytics is designed for Data Integration and holds a mindshare of 1.7%, up 1.1% compared to last year.
SAP Process Orchestration, on the other hand, focuses on Business-to-Business Middleware, holds 6.4% mindshare, down 10.8% since last year.

Data Integration Market Share Distribution
Product	Market Share (%)
Pentaho Data Integration and Analytics	1.7%
Informatica PowerCenter	6.0%
SSIS	5.7%
Other	86.6%

Data Integration

Business-to-Business Middleware Market Share Distribution
Product	Market Share (%)
SAP Process Orchestration	6.4%
IBM Sterling B2B Integration Services	15.1%
webMethods.io	11.9%
Other	66.6%

Business-to-Business Middleware

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

Vasanth Kumar Sabaapathi

Senior Lead Architect at a manufacturing company with 1,001-5,000 employees

Simplified integrations bring flexibility and efficiency to diverse industries through comprehensive features and robust support

SAP is already trying to make improvements for SAP Process Orchestration by releasing updates every quarter, including patches and modules, and from a security standpoint, while it's a tightly coupled tool, they are introducing a lot of enhancements aligned with current market trends. There are standard contents readily available for starting integrations, which suit around 90% of every industry across verticals including pharma, manufacturing, and employee data central with SuccessFactors integration. Regarding functionality-wise improvements in SAP Process Orchestration, they are now incorporating the Salesforce system. Previously, we needed to rely on a third-party adapter for integration within SAP, but now they are building their own adapters to connect with Salesforce. Additionally, there are options like data connectors using Ariba coming up with SAP Process Orchestration. There's much more to explore, especially as they release new patches, enhancements, and adapters each quarter.

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

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

"It is easy to use, install, and start working with."

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

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

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

"Provides a good open source option."

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

More Pentaho Data Integration and Analytics pros

"I rate the product's setup phase a nine on a scale of one to ten, where one is difficult and ten is easy since it is a very easy process."

"The initial setup is easy."

"The monitoring is one of the greatest features in Process Orchestration because it is user-friendly and easy for somebody who is not experienced."

"It is a scalable solution."

"The product has good technical support but you usually will not need it because it is quite stable."

"t is a pretty stable solution. I have not seen any outages in the solution."

"It is simple to transfer files."

"The solution's technical support is good."

More SAP Process Orchestration pros

Cons

"It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively."

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

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

"I would like to see more improvements with AS400 DB2."

"Communicating with the vendor is challenging, and this hinders its performance in free tool setups."

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

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

More Pentaho Data Integration and Analytics cons

"The responsiveness of technical support needs to be improved."

"I think the big improvement required in the tool stems from the fact that the whole issue around it is that we have some downtime failures during upgrades and patching."

"I think the main area that SAP PO should improve on is offering pre-delivered content like they do when you use SAP Cloud Platform Integration (CPI). SAP should not forget that they still have a lot of customers using Process Orchestration and they should focus more on providing pre-delivered content in SAP PO."

"The solution could improve by making it more user-friendly by limiting the code required. We have to add some code in some cases where we need complex logic or some other functions. If this was able to be done in a more simplified manner then it would save a lot of effort and time."

"In terms of technical support, it would be helpful if they handled the tickets a bit faster when queries are sent to them."

"The solution could be more scalable."

"The monitoring governance offered by SAP is too technical and needs to be geared more toward business users."

"This is an on-premise platform and one area they can improve on is having the ability to work with SaaS solutions."

More SAP Process Orchestration cons

Pricing and Cost Advice

"The price of the regular version is not reasonable and it should be lower."

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

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

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

"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 believe the pricing of the solution is more affordable than the competitors"

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

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

More Pentaho Data Integration and Analytics pricing and cost advice

"The product is not a low-priced solution, but I can say that it is competitively priced in the market."

"The cost of SAP products is quite high but the quality is really good."

"The solution is highly-priced."

"The pricing depends on what type of client you are with SAP and the contract you have. There is a licensing cost that needs to be paid."

"My company deals with different pricing models of the product, according to which we don't pay for the solution directly, but we do pay for the maintenance part."

"It is a very expensive solution. We only pay for the license."

"The pricing for this solution is fine."

"It's not an expensive solution."

More SAP Process Orchestration 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

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

15%

Computer Software Company

12%

Retailer

Energy/Utilities Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

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

By reviewers
Company Size	Count
Small Business	8
Midsize Enterprise	3
Large Enterprise	26

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 do you like most about SAP Process Orchestration?

It provides essential features such as continuous monitoring of all interfaces are crucial for our needs.

What is your experience regarding pricing and costs for SAP Process Orchestration?

The price for SAP Process Orchestration is a little high when compared to market trends, which is just how the business is. I would rate it an eight.

What needs improvement with SAP Process Orchestration?

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

Comparisons

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

SAP Data Services vs SAP Process Orchestration

Compared 13% of the time

MuleSoft Anypoint Platform vs SAP Process Orchestration

Compared 13% of the time

IBM Sterling B2B Integration Services vs SAP Process Orchestration

Compared 12% of the time

webMethods.io vs SAP Process Orchestration

Compared 10% of the time

IBM App Connect vs SAP Process Orchestration

Compared 8% of the time

More SAP Process Orchestration Competitors

Product Reports

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

SAP Process Orchestration

Download SAP Process Orchestration product report

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

SAP NetWeaver Process Integration, NetWeaver Process Integration

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

SAP NetWeaver Process Integration facilitates the integration of business processes that span different departments, organizations, or companies. SAP PI is based on general standards so as to enable 3rd-party systems to be integrated. At the center of SAP PI is an XML-based communication that uses HTTP (Hyper Text Transfer Protocol). Irrespective of the scenario used, the application-specific contents are transferred in messages in user-defined XML eXtensible Markup Language) from the sender to the receiver either via the Integration Server, or directly between the systems involved. SAP PI can be installed in different ways: Dual usage type installation: Based on both AS ABAP and AS Java. and Advanced Adapter Engine Extended (AEX): Based on AS Java only.

SAP

Sample Customers

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

Lenovo, Dansk Supermarked A/S, Ego Pharmaceuticals Pty. Ltd, Kaeser Kompressoren

Pentaho Data Integration and Analytics vs. SAP Process Orchestration