← Back to glossary
Category: Tehnologie · Acronym: ETL
ETL (Extract, Transform, Load)
Quick answer: A process where data is extracted from a source, transformed to the target format and loaded into the destination system.
Key takeaways
- ETL — transform before loading (classic)
- ELT — load raw, transform in the destination (common in cloud/data warehouse)
What ETL is
ETL (Extract, Transform, Load) is the classic data-integration pattern: extract from a source (ERP, file, API), transform (cleaning, mapping, code conversion) and load into a destination (another system, data warehouse).
Why it matters
Almost any system-to-system integration is, at its core, an ETL. Transformation quality (correct mapping of codes, UoM, currencies) decides whether data arrives clean or corrupted.
ETL vs ELT
ETL — transform before loading (classic)
ELT — load raw, transform in the destination (common in cloud/data warehouse)
How Azuvio helps
Azuvio runs the necessary transformations between ERP, couriers, marketplaces and EDI partners (code, UoM, structure mapping), so each system receives data in its own format, clean and consistent.
Frequently asked
- Is ETL the same as an integration?
- ETL is the core mechanism of many integrations (it moves and transforms data). A full integration adds orchestration, error handling, retry, monitoring.
- Difference ETL vs ELT?
- In ETL you transform before loading; in ELT you load raw and transform in the destination. ELT is common with cloud data warehouses.
Related terms
- iPaaS (Integration Platform as a Service) — A cloud platform that connects applications and data via connectors, flows and transformations managed centrally.
- Integration middleware — The intermediate software layer that connects systems and translates data between them, decoupling them from each other.
- Data Warehouse — A central store of data consolidated from multiple systems, optimised for reporting and analysis, not operations.
- EDI mapping — Translating between the standard EDI message structure and your ERP's data format, for automatic processing.
Last updated: