Essential Guide

DIY BI: A guide to self-service business intelligence implementation

A comprehensive collection of articles, videos and more, hand-picked by our editors

extract, transform, load (ETL)

In managing databases, extract, transform, load (ETL) refers to three separate functions combined into a single programming tool.

In managing databases, extract, transform, load (ETL) refers to three separate functions combined into a single programming tool. First, the extract function reads data from a specified source database and extracts a desired subset of data. Next, the transform function works with the acquired data - using rules or lookup tables, or creating combinations with other data - to convert it to the desired state. Finally, the load function is used to write the resulting data (either all of the subset or just the changes) to a target database, which may or may not previously exist.

ETL can be used to acquire a temporary subset of data for reports or other purposes, or a more permanent data set may be acquired for other purposes such as: the population of a data mart or data warehouse; conversion from one database type to another; and the migration of data from one database or platform to another.

ETL can be contrasted with ELT (Extract, Load, Transform)  which transfers raw data from a source server to a data warehouse on a target server and then prepares the information for downstream uses. 

compare ETL with ELT

This was first published in November 2005

Continue Reading About extract, transform, load (ETL)

Glossary

'extract, transform, load (ETL)' is part of the:

View All Definitions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Essential Guide

DIY BI: A guide to self-service business intelligence implementation

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close