It allows for very quick development due to the intuitive interface. Compared to other ETL tools like Powercenter, SSIS and SAS DI Studio it excels in rapid development cycles.
Pentaho Data Integration and Analytics offers an intuitive platform for data workflows, enabling users to easily manage ETL processes across diverse data formats, ensuring seamless automation and development.



| Author info | Rating | Review Summary |
|---|---|---|
| Sr BI Administrator at a healthcare company with 1,001-5,000 employees | 4.0 | I find PDI excels at rapid ETL development due to its intuitive interface and community support. However, its administration, monitoring, and GUI stability are weak, often freezing, which impacts my overall experience. |
It allows for very quick development due to the intuitive interface. Compared to other ETL tools like Powercenter, SSIS and SAS DI Studio it excels in rapid development cycles.
It gave ‘out-of-the-box’ widgets for reading XML and JSON interfaces which would otherwise have to be build from scratch.
PDI excels at the development part. Administration and monitoring are pretty weak and basic. But, I must say I have been spoiled with the great capabilities that Powercenter offers ‘out-of-the-box’ The Pentaho development team seems to rely very heavily on Linux/Unix for the admin part. Debugging could be enhanced with better feed-back.
We used PDI 4.3 in a pilot against SSIS during 2013 for a couple of months. In 2014 I have the 4.4 version on a daily basis within a production environment for exactly one year. We also looked into the commercial front-end solution and found this to be too much of a collection of loosely connected applications
There have been no deployment issues.
Stability is a bit of an issue. The GUI quite often ‘freezes’ and the is no alternative to killing the session. Very frequent saving is in order
There have been no issues with scalability.
The community site is pretty brilliant. Every technical component is handled on its own Wiki page. You can even look into the scrum backlog of the dev. team. Absolutely amazing.
Heavy ETL solutions were simply too expensive and the SSIS alternative is simply too hidious to consider. It took at least three times as much time to develop the same ETL proces with SSIS as compared to Pentaho. (And having to deal with the abject Microsoft ‘debugging’.
Incredibily easy. Just unpack, make sure you got the right drivers installed, and beware of other Java applications running.
We simply did everything ourselves, with a little aid from the community.
Make sure Pentaho solutions are still available as they were prior to the commercial take-over. Administration is not the best developed component . The ETL is brilliant. Make sure that the admin part is covered.
| Product | Mindshare (%) |
|---|---|
| Pentaho Data Integration and Analytics | 1.9% |
| SSIS | 4.0% |
| Informatica Intelligent Data Management Cloud (IDMC) | 3.8% |
| Other | 90.3% |
| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 13 |
| Large Enterprise | 24 |
| Company Size | Count |
|---|---|
| Small Business | 284 |
| Midsize Enterprise | 97 |
| Large Enterprise | 186 |
With its drag-and-drop interface, Pentaho allows for efficient ETL workflows without extensive coding. It supports a multitude of data formats and sources such as SQL, NoSQL, Hadoop, CSV, and JSON. Advanced features like metadata injection and API integration enable seamless automation. However, improvements in big data performance, better cloud service integration, and enhanced real-time processing capabilities can enhance user experience. Additional connectors and improved documentation are sought after by many. Providing support for more programming languages and optimizing memory usage also presents opportunities for enhancement.
What are the key features of Pentaho Data Integration and Analytics?Pentaho is employed across finance, healthcare, and retail industries for ETL processes. It's instrumental in integrating data from ERP, SAP systems, Excel, and APIs to develop comprehensive reports and data models. Companies rely on its capabilities for both on-premises and cloud deployments, improving data transparency and management.
Pentaho Data Integration and Analytics was previously known as Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration.
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute