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."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."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"The solution has a free to use community version."
"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."
"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."
"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 abstraction is quite good."
"The user interface is ok."
"The product's most valuable features are data validation and rules."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"The solution offers very good integration capabilities."
"The most valuable feature of SAP Data Services is the integration with data sources."
"The initial setup is not complex."
"The most valuable features of SAP Data Services lie in its ability to effectively observe and interpret the information within data related to people or facts, stands out."
"Technical support from SAP is awesome. If we have an issue, they give a good solution."
"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."
"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."
"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"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."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"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."
"At the integration level, there could be certain set of improvement to connect to various other systems."
"The execution engines and processing engines have shortcomings and need improvements."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"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."
"An area for improvement in SAP Data Services could involve making the product more accessible to non-technical end-users."
"The pricing of the solution should be improved."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 16 reviews while SAP Data Services is ranked 10th in Data Integration with 15 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 "Low-code makes development faster than with Python, but there were caching issues". On the other hand, the top reviewer of SAP Data Services writes "Easy to use, simple to implement, and offers very good mapping capabilities". Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, AWS Glue and Oracle GoldenGate, whereas SAP Data Services is most compared with Azure Data Factory, Syniti Data Quality, Informatica PowerCenter, SSIS 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.