ELT
ELT stands for Extract, Load, Transform: raw data first enters the target store and is then transformed there for the required analyses.
What does ELT mean?
ELT stands for Extract, Load, Transform: read data from a source, load it into a target store first and then transform it there. The raw data is therefore available in the target before the intended preparation takes place. Derived tables or views can be created there for analysis.
In a fictional software project, a background job supplies its runtime as {"durationMs":90000}. In the planned ELT flow, this record first enters the company's target table raw_runs. Only a subsequent transformation in the target calculates 90000 / 1000 = 90 and provides the seconds value as durationSeconds for the report. Table and field names are freely chosen examples; no data pipeline has been run.
With ETL, this conversion would happen before loading into the analytics store. ELT moves it into the target. Which data may be stored there in raw form and who may read it still need to be defined. The order alone guarantees neither faster analyses nor lower costs.
Sources
Related terms
- ETLETL stands for Extract, Transform, Load: data is read from a source, transformed before loading and then transferred into the analytics store.
- Data mappingData mapping defines how source data enters a target structure. Field names, meaning, units and error handling all need to fit.
- System integrationSystem integration links applications, data and work steps. Interfaces alone are insufficient: identifiers, field meanings and outcomes need to agree.
- Transactional inboxA transactional inbox uses durable message records to protect local processing against duplicate deliveries.
- Message acknowledgementA message acknowledgement tells the broker that a delivery has been received or processed according to the agreed rule.
- Retry jitterRetry jitter varies waiting times randomly to spread retries and reduce simultaneous requests from many clients.
Articles on this topic
APIs & Integration with ASES
ERP, CRM and shop cleanly connected