I use Pentaho Data Integration for data integration and ETL processes. I developed with Pentaho from CoproSema. I work on machine learning projects using Pentaho in different projects, such as forecasting for clients who have not paid their credit.
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 |
|---|---|---|
| Data Architecture and Engineering Specialist at coprocenva | 4.0 | I use Pentaho Data Integration for ETL processes, valuing its drag-and-drop feature and JavaScript support for larger datasets. While user-friendly, it’s less effective with smaller data and vendor communication is difficult. I complement it with Power BI and Microsoft Fabric. |
I use Pentaho Data Integration for data integration and ETL processes. I developed with Pentaho from CoproSema. I work on machine learning projects using Pentaho in different projects, such as forecasting for clients who have not paid their credit.
I find the drag and drop feature in Pentaho Data Integration very useful for integration. I can use JavaScript and Java in some notes for ETL development. It's easy to use and friendly, especially for larger data sets.
I use Pentaho for ETLs while relying on other tools like Power BI for data visualization and Microsoft Fabric for other tasks.
While Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle. Communicating with the vendor is challenging, and this hinders its performance in free tool setups.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
Pentaho Data Integration handles larger datasets better. It's not very useful for smaller datasets.
Communication with the vendor is challenging, which makes customer service less satisfactory despite being a free tool.
Neutral
I use Pentaho for data integration, however, for machine learning and business intelligence, I rely on other tools such as Power BI and Microsoft Fabric.
The initial setup of Pentaho is easy and straightforward.
Deploying Pentaho usually requires around two people, possibly with roles such as server administrator or technical lead.
I use Power BI for business intelligence, Microsoft Fabric for other tasks, and AWS Glue for data processing in other projects. I do not have experience with Azure Data Box.
On a scale of one to ten, I would rate Pentaho Data Integration around an eight.
| 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