Its ability of blending data and the dashboarding with C*TOOLS for creating responsive single page apps.
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 |
|---|---|---|
| Datawarehouse Administrator at a tech services company with 501-1,000 employees | 4.0 | I value its data blending and dashboarding but found the setup complex and the user console requires programmer skills. While tech support eventually helps, initial customer service is slow. |
Its ability of blending data and the dashboarding with C*TOOLS for creating responsive single page apps.
We have been able to expose data services through the use of CDA relying on the same database as the reporting tools, thus avoiding inconsistencies among the data shown by reports and data acquired by external systems.
The User Console, aka workspace, and the development of dashboards. They work but they require some programmer skills. This means a continous application management on behalf of IT dept.
I've used it for six years.
There were issues, but they were solved with help from tech support.
There were issues, but they were solved with help from tech support.
There were issues, but they were solved with help from tech support.
It depends, as it takes usually a long time, and some answers are just a way to acquire time and the commitment seems poor. However, when you finally get to an engineer your are likely to have your problem solved in a few days.
We used Microstrategy, Cognos, and Business Objects. The pricing was the key driver, but also the open source licensing which made us think we would have been able to develop on our own improvements. This didn't happen because primarily of the few resources we effectively put on development.
It's complex because of the lack of documentation and the absence of an installer for Linux.
We did it in-house one, and we had to hire some developers for some months with Java skills.
Have a vision, and do not let yourself be guided by the technology.
| 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