Dictionary Term

Extract, Transform, Load


Extract, transform, and load (ETL) is an activity performed by software, in which data sets are moved from their original sources into new databases. ETL is crucial to building and maintaining a current database that can therefore produce relevant business intelligence.

Essentially, ETL tools read data sets, convert those data sets into forms that are compatible with the new database, and then write the data to the new database.

Sources :

http://searchdatamanagement.techtarget.com/definition/extract-transform-load http://docs.oracle.com/cd/B19306_01/server.102/b14223/ettover.htm http://www.webopedia.com/TERM/E/ETL.html

Back to Dictionary