I have a team who has experience with integration. We are service providers and partners. Generally, clients buy the product directly from the company.
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 |
|---|---|---|
| Assosiate Partner at Autana Business Partners | 3.5 | I find Pentaho Data Integration and Analytics easy to use and install, particularly for small data volumes, though it struggles with larger datasets compared to Talend or Informatica. The excellent price-to-functionality ratio saves us up to 30%. |

I have a team who has experience with integration. We are service providers and partners. Generally, clients buy the product directly from the company.
It is easy to use, install, and start working with. This is one of the advantages compared to other key vaulting products. The relationship between price and functionality is excellent, resulting in time and money savings of between twenty-five and thirty percent.
One of the advantages is that it is easy to use, install, and start working with. For certain volumes of data, the solution is very efficient.
Pentaho may be less efficient for large volumes of data compared to other solutions like Talend or Informatica. Larger data jobs take more time to execute.
Pentaho is more appropriate for jobs with smaller volumes of data.
I have used the solution for more than ten years.
The solution is stable. Generally, one person can manage and maintain it.
Sometimes, for large volumes of data, a different solution might be more appropriate. Pentaho is suited for smaller volumes of data, while Talend is better for larger volumes.
Based on my experience, the solution has been reliable.
Positive
We did a comparison between Talend and Pentaho last year.
The initial setup is straightforward. It is easy to install and start working with.
A team with experience in integration manages the implementation.
The relationship between price and functionality is excellent. It results in time and money savings of between twenty-five and thirty percent.
Pentaho is cheaper than other solutions. The relationship between price and functionality means it provides good value for money.
We evaluated Talend and Pentaho.
I'd rate the solution seven out of ten.
| 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