ETL, ELT and reverse ETL
The popular acronym for Extracting, Transforming and Loading data (also called data pipeline tools or data integration). ELT performs data transformations directly within the data warehouse. Reverse ETL is the process of copying data from your datawarehouse to external tools or SaaS.
- Airbyte - Open-source ELT platform with 300+ pre-built connectors for syncing data to your warehouse.
- Census - Reverse ETL platform for syncing data warehouse data to CRMs, ad tools, and other SaaS.
- dbt - SQL-based transformation framework that runs inside your warehouse; the standard tool for the T in ELT.
- Debezium - Open-source CDC (Change Data Capture) platform that streams row-level changes from databases like PostgreSQL, MySQL, and MongoDB into Kafka and downstream systems.
- RudderStack - Customer Data Platform providing a pipeline between a tracking plan, event transformation, and destination tools.