We are using just the simple features of this product.
We're using it as a data warehouse and then for building dimensions.
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 |
|---|---|---|
| Assistant General Manager at DTDC Express Limited | 3.5 | I find Pentaho stable and scalable for batch processing, using it for data warehousing. Setup was easy, and the community version is free. However, it lacks GCS connectivity and real-time processing, and the regular version is too expensive. I rate it 7/10. |
We are using just the simple features of this product.
We're using it as a data warehouse and then for building dimensions.
The shortcoming in version 7 is that we are unable to connect to Google Cloud Storage (GCS), where I can write the results from Pentaho. I'm able to connect to S3 using Pentaho 8, but when using it for GCS, I'm unable to connect. With people moving from on-premises deployments to the cloud, be it S3, Azure, or Google, we need a plugin where we can interact with these cloud vendors.
I would like to see improvements made for real-time data processing. It is something that I will be looking out for.
For all of the features that we have been using, it is a stable product.
In terms of data loading and processes, the scalability is good.
We have a team of four people who are using it for analytics.
As we are using the Community Version, we have not been in contact with technical support. Instead, we rely on forums and websites when we need to resolve a problem.
In the past, I have worked with Talend, as well as SAP BO Data Services (BODS). However, that was with another company. This organization started with Pentaho and we are still using it.
It is a straightforward setup process. It took between three and four hours to complete.
We are using the Community Version, which is available free of charge.
The price of the regular version is not reasonable and it should be lower.
My advice for anybody who is researching this product is that if they want to do batch processing, then this is a good choice. The amount of data that it loads and processes is good.
Based on the features that I have used and my experience, I would rate this solution a 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 | 286 |
| 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