Skip to content
EVIDENTCORE
DatasyncherGuide

What is ELT?

Extract, load, transform, and why loading before transforming suits the cloud.

Delivered, implemented and supported by EVIDENTCORE

1

Extract

Data is read from source systems such as SAP S/4HANA, Dynamics 365, Salesforce, NetSuite, databases and files, with as little load on those systems as possible.

2

Load

Raw data lands in a cloud warehouse or lake such as Snowflake, Databricks, Microsoft Fabric, Amazon S3 or ADLS. Loading first keeps a full-fidelity copy and decouples ingestion from modeling.

3

Transform

Transformation then runs where compute is elastic: in the warehouse, or with a Python step during the pipeline for cleansing and enrichment that shouldn't wait.

4

Why ELT over ETL

Cloud platforms make storage cheap and compute elastic. ELT lets teams re-model historical data without re-extracting it, and keeps pipelines simpler to operate.

Next guideWhat is Reverse ETL?

See it on your own data

EVIDENTCORE runs a proof of concept with one source, one destination and one report.