Pentaho Data Integration Archived Reviews (More than two years old)

Filter by:Reset all filters
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
Filter Unavailable
Filter Unavailable
Order by:
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Leonardo de Andrade
Real User
Brazil IT Coordinator at a transportation company with 1,001-5,000 employees
Aug 24 2017

What do you think of Pentaho Data Integration?

What is most valuable?

Data transformation within Pentaho is a nice feature that they have and that I value.

How has it helped my organization?

Integration between databases and data import for a BI solution.

What needs improvement?

I would like to see more improvements with AS400 DB2. I journalled the tables/instance and the data migration is too slow if I compare it with other databases.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

Until now, the stability of Pentaho is great. I've already tested various scenarios and I didn't feel a loss of performance.

What do I think about the scalability of the solution?

There have been no issues so far in scaling the…
Senior Consultant at a financial services firm with 10,001+ employees
Aug 09 2016

What is most valuable?

It allows for rapid prototyping of a wide array of ETL workloads.

What needs improvement?

Support for common Hadoop utilities can be expanded, such as bulk load with composite row keys for HBase, and include drivers for Impala out-of-the-box. A richer interface to Hive could also be beneficial as we currently have to go through a raw connection and execute SQL scripts, for which some syntax is not respected. As of version 6, there are also some new issues introduced that pose a bit of an annoyance: 1) On kettle's ramp up - log4j errors 2) IBM Websphere MQ Producer - variable substitution for the URL does not work - you have to hardcode. 3) shared.xml for DB connections - variable… more»
Find out what your peers are saying about Hitachi, Microsoft, IBM and others in Data Integration Tools. Updated: May 2020.
419,536 professionals have used our research since 2012.
Business Intelligence Consultant at Sanmargar Team
Feb 24 2016

What is most valuable?

First of all, the ease of deployment. I’m pretty sure that almost anyone could do simple transformations without having any knowledge of IT. Thanks to its graphical interface this tool is just drag… more»

How has it helped my organization?

We use it almost everywhere, for creating data marts, data warehouses, and implementing BI reporting tools. We also build our Customer Centralized File and Data Quality Studio using it. What’s more… more»

What needs improvement?

A big advantage, but also a problem, is that it is open source. Almost anyone can develop their own Pentaho code and release it. Now, Pentaho is a little messy, and some parts of it are super new and… more»

What's my experience with pricing, setup cost, and licensing?

There is a Community Edition which is free. There is also an Enterprise licence but the price varies depending on the server hardware configuration and the purpose of use (BigData, Hadoop, etc.).

What other advice do I have?

The tool is excellent, and almost everyone can use it. You just need to take it out of the box and run. There is no limit to the application – you can do everything with it. However, it still has a… more»

Which other solutions did I evaluate?

I had the chance to test SAS Data Integration but I didn’t fall in love with it like I did with PDI. I think that PDI is easier to use and you can do much more with PDI than with SAS.

What is Pentaho Data Integration?

Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.

Also known as
Pentaho Data Integration customers
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Download our free Data Integration Tools Report and find out what your peers are saying about Hitachi, Microsoft, IBM, and more!