ETL (EN)

Concept

Extract, Transform, Load - classic approach to data integration

ETL Process

flowchart TD     A[Source Systems] --> B[Extraction]     B --> C[Transformation Area]     C --> D[Transformation & Cleaning]     D --> E[Target System]     E --> F[Analysis & Reporting]

In Context

  • Typically used together with Data Warehousing and Business Intelligence
  • Related to: ELT, Data Integration, Data Pipeline
  • Example use case: Consolidating customer data from various CRM systems for central reporting
Quelle: AI Generated