Back to Glossary

Data integration process

ETL

Extracting data, transforming them into the required form and loading them into a target environment.

Related domain: Data AnalyticsConcept ID: concept-etl

Definition

ETL (Extract, Transform, Load) is a process that extracts data from different sources, transforms them into the required form and loads them into a target storage environment.

Human Explanation

Data are first extracted, then cleaned and transformed, and only afterwards stored in the destination.

Why it Matters

ETL enables data from multiple systems to be integrated and prepared for analysis.

Conceptual Boundary

ETL describes the order of operations. It does not specify a particular tool or technology.

Practical Perspective

ETL is commonly used with traditional data warehouses and reporting environments.

Related Concepts