We performed a comparison between Pentaho Data Integration and Analytics and SAP Process Orchestration 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."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."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."
"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."
"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"Provides a good open source option."
"It is a scalable solution."
"The most valuable feature is the seamless integration with backend systems."
"The most valuable features of SAP Process Orchestration are the standard APIs that we can use."
"With the latest version what I find to be the most valuable are the REST, SuccessFactors, and Ariba Network adapters."
"Process Orchestration fulfils the need for middleware to mediate types of connectivity."
"The solution provides very good and central logging systems. It offers high flexibility with vertical and horizontal extend capacity."
"It provides essential features such as continuous monitoring of all interfaces are crucial for our needs."
"The most valuable feature of SAP Process Orchestration is its flexibility in being able to build integrations with SAP systems and non-SAP systems."
"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'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."
"I work with different databases. I would like to work with more connectors to new databases, e.g., DynamoDB and MariaDB, and new cloud solutions, e.g., AWS, Azure, and GCP. If they had these connectors, that would be great. They could improve by building new connectors. If you have native connections to different databases, then you can make instructions more efficient and in a more natural way. You don't have to write any scripts to use that connector."
"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."
"I would like to see more improvements with AS400 DB2."
"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."
"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."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"Process Orchestration doesn't provide authentication for data sent to us, meaning we have to rely on client certificate-based or basic authentication."
"The cloud capability features need improvement."
"The solution is not very scalable because it is at the end of its life."
"The product roadmap suggests it will approach the end of support in several years, and a lot of innovations are now implemented by SAP not in SAP PO, but in SAP Integration Suite, hence, the platform is stable, but doesn't receive a lot of new features in recent updates."
"It is scalable, but there can be performance issues with high data volume or traffic, especially during month ends."
"In terms of technical support, it would be helpful if they handled the tickets a bit faster when queries are sent to them."
"We encounter challenges while connecting to MQTT and MQDD adapters."
"It does not have all of the industry-standard solutions available in PO and it is not plug and play, so we have to do a lot of development."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 48 reviews while SAP Process Orchestration is ranked 1st in Business-to-Business Middleware with 28 reviews. Pentaho Data Integration and Analytics is rated 8.0, while SAP Process Orchestration is rated 8.2. The top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". On the other hand, the top reviewer of SAP Process Orchestration writes "A tool that can be useful for small integrations and large integrations". Pentaho Data Integration and Analytics is most compared with SSIS, Azure Data Factory, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue, whereas SAP Process Orchestration is most compared with Mule Anypoint Platform, SAP Data Services, IBM Sterling B2B Integration Services, webMethods Integration Server and IBM B2B Integrator. See our Pentaho Data Integration and Analytics vs. SAP Process Orchestration report.
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.