extract, transform, and load (ETL)

A single process made up of three database functions used to migrate data between databases, form data marts, convert databases from one format to another, and so on. The ETL process involves extracting data from a source database, transforming the data to fit operational needs, and then loading the data into the target, usually another database or a data warehouse.