Pentaho Data Integration and Analytics vs SAP Process Orchestration comparison

Pentaho Data Integration and Analytics vs. SAP Process Orchestration

Download the complete report

Helped 885,311 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.7

Number of Reviews

Ranking in other categories

Data Integration (8th)

SAP Process Orchestration

Average Rating

8.2

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Business-to-Business Middleware (7th)

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.6%, up 1.4% compared to last year.
SAP Process Orchestration, on the other hand, focuses on Business-to-Business Middleware, holds 5.1% mindshare, down 8.7% since last year.

Data Integration Mindshare Distribution
Product	Mindshare (%)
Pentaho Data Integration and Analytics	1.6%
SSIS	3.6%
Informatica Intelligent Data Management Cloud (IDMC)	3.6%
Other	91.2%

Data Integration

Business-to-Business Middleware Mindshare Distribution
Product	Mindshare (%)
SAP Process Orchestration	5.1%
IBM Sterling B2B Integration Services	13.2%
SEEBURGER Business Integration Suite	10.9%
Other	70.80000000000001%

Business-to-Business Middleware

Featured Reviews

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

Streamlines complex data workflows and has supported automated customer payment notifications

I haven't used Pentaho Data Integration and Analytics in a couple of years, so I don't know how it can be improved. I was pretty pleased with it and was self-taught on it, working a lot with their team at various times, but they were surprised that I was able to learn it all by myself. The documentation is not bad, and documentation is the main thing that any product can do to make themselves better because the easier it is to find examples of what you're trying to do improves the learning curve. I think it took me the longest to learn how to do the asynchronous processing and have things wait for other things to finish processing before continuing on in the workflow. I choose 8 out of 10 because the one reason that it's been rejected at T-Mobile is that everything has to go through a provisioning process and has to get approved, meaning the actual code base has to be investigated by T-Mobile before they'll allow us to use tools of that nature. For whatever reason, we just haven't been able to get that approval; I don't know if it's on Pentaho Data Integration and Analytics' side or if it's on our side. The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.

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

"Pentaho Data Integration and Analytics positively impacted my organization by organizing data that was scattered across many different databases and APIs, reducing a lot of manual work and centralizing it into one data warehouse."

"The amount of data that it loads and processes is good."

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

"We are very productive today thanks to that piece of software integration our data and the platform serving the processed data to our users."

"From my perspective I don't see the difference, we can do almost everything with Pentaho Kettle and if we need a little extra we are tech guys, we solve it."

"Pentaho Data Integration is easy to use, especially when transforming data."

"Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing."

"It is a very good tool if you need to work with data."

More Pentaho Data Integration and Analytics pros

"Someone who has to work on a PO should at least have a basic understanding of Java because as it is an integration tool, the way SAP provides to transform the messages from one structure to another is very good."

"It is simple to transfer files."

"The most valuable feature is the seamless integration with backend systems."

"It is strategically focused to forecast a global integration platform for our business."

"With the latest version what I find to be the most valuable are the REST, SuccessFactors, and Ariba Network adapters."

"In my opinion, SAP PO is the most mature suite of tools to integrate processes across SAP environments at this moment. It's really unbeatable because it allows you to integrate whatever scenarios you can imagine."

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

"Orchestration is beneficial for us."

More SAP Process Orchestration pros

Cons

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

"In the community version the scheduling tool is not good, and we had to build it ourselves."

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

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

"For managing very large volumes of data, Pentaho Data Integration and Analytics is not the best tool, but it is in a good position to handle millions of records."

"As far as I remember, not all connectors worked very well."

"Searching repository for reports or dashboards"

"The reporting definitely needs improvement. There are a lot of general, basic features that it doesn't have."

More Pentaho Data Integration and Analytics cons

"I feel that support is an area that needs improvement. They need to improve the response time and address the customer's issues as soon as possible."

"Data modeling is an area of concern in the product where improvements are required."

"The solution isn't meant to scale when high-volume transactions are in play; the scalability could improve."

"The usability, for example, is an area where it can be improved upon."

"SAP Process Orchestration breaks down sometimes."

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

"The solution needs to move to the cloud."

"It requires some maintenance."

More SAP Process Orchestration cons

Pricing and Cost Advice

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

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

"If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"

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

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

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

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

More Pentaho Data Integration and Analytics pricing and cost advice

"Normally, you will have to choose CPU-based licensing...I rate the tool price a five out of ten."

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

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

"There are fees in addition to the licensing."

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

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

"The price of SAP Process Orchestration was reasonable."

"The pricing for this solution is fine."

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

885,311 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

11%

Educational Organization

Government

Manufacturing Company

12%

Computer Software Company

12%

Retailer

Outsourcing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	17
Large Enterprise	31

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

What is your primary use case for SAP Process Orchestration?

The main use case for SAP Process Orchestration is that it's an SAP proprietary tool which integrates within SAP and outside SAP. It's the most familiar middleware tool which is used for integrations.

Airbyte Cloud vs Pentaho Data Integration and Analytics

Comparisons

Compared 16% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 8% of the time

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

Compared 6% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 6% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 5% of the time

More Pentaho Data Integration and Analytics Competitors

IBM Sterling B2B Integration Services vs SAP Process Orchestration

Compared 10% of the time

webMethods.io vs SAP Process Orchestration

Compared 7% of the time

MuleSoft Anypoint Platform vs SAP Process Orchestration

Compared 6% of the time

Microsoft Graph Data Connect vs SAP Process Orchestration

Compared 6% of the time

Palantir Foundry vs SAP Process Orchestration

Compared 6% 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