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)

PRO+

Content

Find more PRO+ content and other member only offers, here.

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