We performed a comparison between Pentaho Data Integration and Analytics and SAS Data Management based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."
"Provides a good open source option."
"The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data."
"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."
"It's my understanding that the product can scale."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"If you compare it to SQL, the memory and development times are very quick."
"The tool is reliable, quick, and powerful."
"The product offers very good flexibility."
"I am impressed with the tool's ability to customize."
"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."
"The technical support is excellent."
"This is an established product with powerful data analysis and varied options for user entry points."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"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."
"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."
"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."
"I would like to see more improvements with AS400 DB2."
"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"One problem is accessing the data using a solution other than SAS. The SAS data, which we create in the SAS, cannot be accessed by other tools. We can't open those data in other applications. So we need to have that application in place."
"The solution is quite expensive and hard to install/configure."
"The solution could use better documentation."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."
"I would like the tool to include the ability to automate the modifications of the integrations."
"We find we often have to go back and re-train users when there are changes made to the solution because the changes are not intuitive."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
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 SAS Data Management is ranked 43rd in Data Integration with 15 reviews. Pentaho Data Integration and Analytics is rated 8.0, while SAS Data Management is rated 8.4. 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 SAS Data Management writes "A scalable solution with customer support that is responsive and diligent". Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue, whereas SAS Data Management is most compared with Informatica PowerCenter, Tungsten RPA, Microsoft Purview, Palantir Foundry and IBM InfoSphere DataStage.
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.