Extract, transform and load (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

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.