BI Glossary - Extract, transform and load (ETL)

Business Intelligence BI Glossary - Extract, transform and load (ETL)

Extraction, transformation, and loading (of data). Term used to describe the process of extracting data our of a production system, then transforming and cleansing it before loading it into a database dedicated to business intelligence. The term is also used to describe a software industry segment and set of software products designed to manage the data extraction, transformation, and loading process.