Pentaho Data Integration – Kettle
Pentaho Data Integration - Kettle delivers powerful Extraction, Transformation, and Loading (ETL) capabilities, using a groundbreaking, metadata-driven approach.
Pentaho Data Integration – Kettle delivers powerful Extraction, Transformation, and Loading (ETL) capabilities, using a groundbreaking, metadata-driven approach. Pentaho ETL is an intuitive, graphical, drag and drop design environment and a proven, scalable, standards-based architecture. Pentaho Data Integration also called Kettle is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes. Features include migrating data between applications or databases, exporting data from databases to flat files, loading data massively into databases, data cleansing and integrating applications.The Data Services and Kettle JDBC driver enable you to deliver data from multiple data sources, while enriching, cleansing, and transforming the data. PDI provides load balancing of data within transformations and over multiple cluster nodes when using transformation clustering.Database connections can be used with all jobs. This enables commits and rollbacks on a job level. Prior to this release, this was only possible with transformations.