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."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."
"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."
"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."
"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."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"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."
"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."
"I appreciate having access to the SAP data."
"The basic functionality is quite good as is the basic logic and data information."
"The most valuable feature is the logging capability."
"The feature of SAP Data Services has enhanced our company's business processes because we are able to run around 800 jobs in areas like data extraction and transaction objects."
"Technical support from SAP is awesome. If we have an issue, they give a good solution."
"The user interface is ok."
"The most valuable feature of SAP Data Services is the integration with data sources."
"The logic is also simple. It makes it easy to build your extraction."
"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."
"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 would like to see more improvements with AS400 DB2."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."
"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 performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"I want some more business intelligence applications. People need to know more and more about data, including the transformation rules, etc. Informatica is a better product for data cataloging. SAP should update the data catalog."
"The description of error messages isn't extensive, although they point to the problem. With other solutions, like Talend, I was able to use the debugger to get directly to the problem, but with SAP Data Services the debugger is not working. I'm not sure if it's a problem with the version specifically, but I'm using it in an enterprise environment and I can't do an upgrade."
"The solution should offer more machine learning and automation."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"Integration with other products could be improved."
"The initial setup is complex."
"There should be some kind of enhancement that can be done on the admin side of certain sites where we can assign the roles and responsibilities. We should be able to control who is using the tool and how."
"With SAP Data Services, the problem arises when I try to connect to Azure Databricks."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews while SAP Data Services is ranked 10th in Data Integration with 45 reviews. Pentaho Data Integration and Analytics is rated 8.0, while SAP Data Services is rated 8.0. 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 Data Services writes "Responsive support, scalable, and beneficial integration". Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, Oracle Data Integrator (ODI) and Oracle GoldenGate, whereas SAP Data Services is most compared with Azure Data Factory, Syniti Data Quality, Informatica PowerCenter, SAP Process Orchestration and Palantir Foundry. 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.