extract, transform, load

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?
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
Data warehouse appliances -- in a nutshell: This guide provides an overview of data warehouse appliance trends and concepts. Get tips for advancing a data warehouse strategy, learn the benefits of data warehousing and more.
	Data management books: Read sample chapters from industry-renowned data management books. Browse free excerpts about BI, compliance and security, EDI, data warehousing, data quality and data governance.
Data model patterns: A metadata map: Read this excerpt from Data Model Patterns: A Metadata Map for a guide to all things metadata. That is, data about data.

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 Microsoft details self-service business intelligence, data warehouse releases Microsoft has taken the wraps off its upcoming BI and data warehouse releases, an Excel add-on called PowerPivot and a massive parallel processing... Why pay for a data warehouse appliance when you can get one free? Data warehouse appliance vendors Greenplum and ParAccel are giving away their products in an attempt to differentiate themselves in a highly... In-database analytics pulls together SAS, data warehouse vendors SAS is working on in-database analytics initiatives with several data warehouse vendors that want its data mining applications to run inside their...

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.