Extract-Transform-Load
lastmod 2026-02-22created 2026-02-221 edits
Extract, transform, load (ETL) is a process of database usage in computing, especially in data warehouses, that encompasses the following:
- Extracting data from homogeneous or heterogeneous data sources.
- Transforming the data to store it in a proper format or structure for querying or analysis.
- Loading the transformed data into the final target (a database, especially an operational data store, data mart, or data warehouse).
Open-source tools
- Talend - Open Studio for Data Integration.
- Pentaho - Data Integration
- Jaspersoft ETL Archived 2016-02-23 - Wayback Machine
- KNIME
- Apache NIFI
- Rhino ETL
- StreamSets
- InnoQuartz ETL
Commercial tools
Commercially available ETL tools include the following.
- Adeptia
- Alooma Archived 2016-02-20 - Wayback Machine
- Analytics Canvas
- Anatella
- Alteryx
- Benetl (freeware)
- Boomi (Dell)
- CampaignRunner
- ESF Database Migration Toolkit
- Informatica PowerCenter
- Talend
- InnoQuartz
- IBM InfoSphere DataStage
- Ab Initio
- Oracle Data Integrator (ODI)
- Oracle Warehouse Builder (OWB)
- Microsoft SQL Server Integration Services (SSIS)
- Tomahawk Business Integrator (Novasoft Technologies)
- Pentaho Data Integration (or Kettle)
- Stambia
- Diyotta DI-SUITE for Modern Data Integration
- FlyData
- SAP BusinessObjects Data Services
- SAS Data Integration Studio
- Skyvia
- SnapLogic
- Clover ETL
- SQ-ALL
- North Concepts Data Pipeline
- TeraStream (Korean-made)
- Simple Data Integrator