What Are ETL and ELT Tools?
6 entriesETL (extract, transform, load) tools pull data from sources, reshape it and load it into a target; ELT tools load raw data first and transform it inside the warehouse or lakehouse, often with SQL tools such as dbt. Modern pipelines mix both, and many managed services bundle connectors, scheduling and monitoring. Descriptions below follow each vendor's or project's own pages and are not rankings; release facts come from GitHub and PyPI.
Open-Source ETL and ELT Tools
10 entriesSelf-hosted extraction, loading and integration tools.
Transformation Tools (the T in ELT)
3 entriesTools that transform data inside the warehouse.
Enterprise ETL Platforms
8 entriesEstablished vendors with broad connectivity and governance.
Cloud ETL Services
6 entriesManaged ETL and data integration from the major clouds and lakehouse vendors.
Managed ELT Services
8 entriesHosted connectors and pipelines.
More ETL Resources
2 entriesFurther ETL tools.
Open ETL & ELT
7 entriesOpen ETL.
Related Pages
2 entriesRelated research directories on this site.
Frequently Asked Questions
What is ETL?
Extract, transform, load: pulling data from source systems, transforming it into the shape needed and loading it into a target such as a data warehouse. Transformation happens before loading.
What is the difference between ETL and ELT?
ELT loads raw data into the warehouse or lakehouse first and transforms it there, usually with SQL tools such as dbt or SQLMesh. It uses the warehouse's compute and keeps raw data available, while ETL transforms in a separate engine before loading.
When should I use CDC instead of batch ETL?
Use change data capture when you need low-latency replication or want to avoid heavy queries on production databases, since it reads the database log. See the Change Data Capture Platforms page.
Should I build with open source or buy a managed ELT service?
Open-source tools such as Airbyte, Meltano and dlt give control and avoid per-row pricing but need operations work. Managed services such as Fivetran, Matillion and Stitch remove maintenance. Many teams combine a managed loader with dbt for transformation.
What happened to dbt and Fivetran?
Fivetran and dbt Labs completed their merger in June 2026, according to their press release, and Fivetran announced its acquisition of Tobiko Data, the company behind SQLMesh and SQLGlot, in September 2025.
What is reverse ETL?
Reverse ETL copies modeled data from the warehouse back into operational tools such as CRMs and marketing systems, so teams can act on it. It is the opposite direction of ETL and ELT, which load data into the warehouse.
How do I choose between ETL tools?
Match the tool to your sources, volumes, latency and team skills. Compare connector coverage, pricing model (per row, per connector or compute), transformation approach, deployment (self-hosted or managed), and how it fits with orchestration, data quality and lineage tools.
Which related standards, open tools and references does this page add?
The section 'More ETL Resources' lists Apache Airflow, Dagster, dlt, Meltano. Further ETL tools.
Where can I find more tool directories?
The Software Tools Directory page links to curated directories across AI and ML, DevOps, observability, data, security and developer tooling.
Which additional references does this page add?
The section 'Open ETL & ELT' lists Airbyte, dbt, Meltano, Apache Beam, dlt.
How current is this page?
Outbound links were checked on 3 November 2026 and all returned 200 except sap.com (403 to automated checks), which is kept and may need a manual click. On 3 November 2026 PyPI and Maven Central matched the versions quoted for dbt-core, SQLMesh, Meltano, dlt, the Singer SDK, Apache SeaTunnel and Apache Hop; Apache NiFi 2.12.0 and Airbyte were not re-checked. Acquisitions and product names change often, so confirm details with each vendor. Vendor descriptions follow their own pages and are not rankings.