Glossary
ETL (extract, transform, load)
A pattern that extracts data, cleans and reshapes it, then loads it into a target system.
ETL stands for extract, transform, load. Data is pulled from source systems, cleaned and reshaped in a separate processing step, and then loaded into a destination such as a data warehouse. The closely related ELT pattern loads the raw data first and transforms it inside the destination, which is common on modern cloud platforms.
ETL still fits when data must be filtered, masked or standardized before it lands, for example to keep sensitive fields out of the warehouse. ELT fits when the platform has cheap storage and strong compute, so raw data can be kept and reshaped later.
Change data capture is a separate choice about how changes are picked up from a source database. Orchestration, meaning scheduling, retries and dependencies, is a third. Treat the three as separate decisions.
Start in 60 seconds
Put this to work on your project.
Get an AI-assisted, architect-reviewed scope, cost range, and timeline. Free, no login.