
	extract, transform, load


	Home > Data management / BI Definitions - Extract, transform, load

SearchDataManagement.com Definitions (Powered by WhatIs.com)

EMAIL THIS

LOOK UP TECH TERMS		Powered by:

Browse tech terms alphabetically:

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

extract, transform, load

Show me everything on Data warehouse software

- 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.

Getting started with ETL

To explore how ETL is used in the enterprise, here are some additional resources:

ETL tools defined: Although ETL tools are useful for moving data from one system into another system, our expert advises that they're not optimal for application-to-application communication.

ETL tools tutorial: This short, informative podcast discusses ETL software, including explanantion, common applications, and the advantages and disadvantages of different tools.

Extract, transform and load (ETL) tools transforming, study finds: The ETL tools market is transforming and growing to facilitate all kinds of data movement. Learn more about the trends and leaders in the ETL space in this article.

ETL tools and EDR tools: What's the difference?: Get expert insight into the differences between ETL tools and enterprise data replication (EDR) tools from Jill Dyché.

Learn more about Data warehouse software

Data Warehouse Platforms Product Directory: Inside this data warehouse platform product directory you'll find basic information about the major vendors in the data warehouse market and the products they sell.
How to evaluate data warehouse software in five steps: What's the process for evaluating data warehouse software?
How to choose between the Inmon vs. Kimball approach for data warehouse design: What's your take on the Ralph Kimball vs. Bill Inmon approaches to data warehouse design?
Understanding and comparing six types of processing systems: Learn about six types of processing systems and how transaction processing systems compare with batch processing, real-time, data warehouse, timesharing and client/ server systems.
Key benchmarks for measuring transaction processing performance: Find key benchmarks for measuring transaction processing performance at your company, plus learn about XA two-phase commit and types of transaction processing.
Transaction processing system examples and SOA approaches: Learn about transaction processing systems, processing systems components and different service-oriented architecture approaches, including representational state transfer.
Data Warehouse Platforms Product Directory: Inside this data warehouse platform product directory you'll find basic information about the major vendors in the data warehouse market and the products they sell.
SearchDataManagement.com product directory library: These product directories are designed to assist organizations in evaluating and purchasing data management software

LAST UPDATED:

23 Sep 2008

Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com

FILE EXTENSION AND FILE FORMAT LIST
File Extension and File Format List:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

RELATED CONTENT

	Oracle's data warehouse strategy unclear after Sun acquisition With its acquisition of Sun Microsystems complete, Oracle faces a slew of questions regarding its data warehouse strategy.
	Mega-vendors dominate Gartner's 2010 BI, data warehouse Magic Quadrants IT heavyweights Oracle, IBM and Microsoft continue to control large segments of the BI software and data warehouse markets, according to Gartner's...
	Transaction processing system examples and SOA approaches Learn about transaction processing systems, processing systems components and different service-oriented architecture approaches, including...

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

data modeling (SearchDataManagement.com)
Data modeling is the analysis of data objects that are used in a business or other context and the identification of the relationships among these...

OLAP (SearchDataManagement.com)
OLAP (online analytical processing) enables a user to easily and selectively extract and view data from different points-of-view.

extract, transform, load Research White Papers

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2010, TechTarget \| Read our Privacy Policy