Extract, transform and load (ETL)

ETL

What is ETL?

Extract, transform, and load (ETL) is the process of combining data from multiple sources into a large, central repository called a data warehouse. ETL uses a set of business rules to clean and organize raw data and prepare it for for example storage, data analytics, machine learning (ML), etc

Extract

the data from its original source, whether that is another database or an application

Transform

data by cleaning it up, deduplicating it, combining it, and otherwise getting ready to…

Load

the data into the target database or platform
Typically, one ETL tool does all three of these steps, and is a critical part of ensuring that data required for reporting, analytics, and, now, machine learning and artificial intelligence is complete and usable. But the nature of ETL, the data it handles, and where the process takes place has evolved tremendously over the last decade–and the right ETL software is more critical than ever.
By clicking "Accept", you agree to the storing of cookies on your device to enhance site navigation, analyse site usage, and assist in our marketing efforts.
Accept
Settings