Choose Index below for a list of all words and phrases defined in this glossary.


Extract, Transform, Load (ETL)

index | Index

Extract Transform Load (ETL) - definitions

Extract Transform Load (ETL) - Extract, transform and load (ETL) is a process used in data warehousing that involves extracting data from outside data sources, then transforming it to fit business needs, then loading it into a data warehouse.

[Category=Data Governance ]

Source: The Data Governance Institute, 03 December 2009 10:12:34, http://www.datagovernance.com/glossary-governance/ External


These advertisers support this free service


ETL (Extract, Transform, Load) - ETL refers to the process of getting data out of one data store (Extract), modifiying it (Transform), and inserting it into a different data store (Load).

[Category=Data Warehousing ]

Source: SDG Computing Inc., 08 May 2010 09:04:48, SDG Computing, now offline


ETL (extraction, transformation and loading) - Tools for extracting data and its metadata from one data store, transforming the record structure and content of this data, and loading the transformed data to another data store. These tools are sometimes referred to as extraction/transformation/transport or ETT technology.

[Category=Data Cleansing ]

Source: X4DB, 19 May 2010 09:25:33, http://www.x4db.com/glossary.html External


ETL - Extract, transform and load (ETL) software does just that"”it extracts records/fields from one data source, converts the data to new formats and provides the ability to load the data to other target destinations, in other words data handling and processing that precedes final storage in the repository.

[Category=Information Management ]

Source: Information-Management.com, 18 June 2010 08:27:00, http://www.information-management.com/glossary/e.html External


ETL - ETL (extract, transform, load) software does just that, it extracts records/fields from one data source, converts the data to new formats and provides the ability to load the data to other target destinations, in other words data handling and processing that precedes final storage in the repository.

[Category=Data Management ]

Source: DataMentors, 19 August 2010 12:59:31, http://www.datamentors.com/News-and-Resources/Glossary.html External


ETL - Stands for Extraction, Tansformation, and Loading. The movement of data from one area to another.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 06 December 2010 09:40:05, http://www.aexis.eu/DataWarehouse-Glossary/ External


ETL - Extract, transform and load. The capability to process and format data prior to load into a database.

[Category=Database Marketing ]

Source: DBG, 04 May 2011 08:05:58, http://www.dbg.co.uk/glossary/1015 External


Extract, Transform and Load (ETL) - Extraction, transformation, and loading (of data). Term used to describe the process of extracting data out 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.

[Category=Business Intelligence ]

Source: ElegantJ BI Business Intelligence, 30 October 2012 10:08:38, http://www.elegantjbi.com/resources/glossary_a.htm External


ETL - Short for Extract-Transform-and Load, ETL is the means by which data is pulled from a data source (extracted), scrubbed (transformed), and written (loaded) into the destination database.

[Category=Business Intelligence ]

Source: Deanna Dicken, 07 November 2012 09:46:26, http://www.databasejournal.com/features/mssql/article.php/3919011/Business-Intelligence-Terminology-101.htm External 


extract, transform, load (ETL) - 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.

Related glossary terms: big data analytics, Apache Hive, On-Line Analytical Processing (OLAP), tree structure, data warehouse appliance

[Category=Data Management ]

Source: WhatIs.com, 03 August 2013 09:17:34, http://whatis.techtarget.com/glossary/Data-and-Data-Management External  


Extract, Transform and Load (ETL) – a process in a database and data warehousing meaning extracting the data from various sources, transforming it to fit operational needs and loading it into the database.

[Category=Big Data ]

Source: BigData-Startup, 27 September 2013 09:02:20, http://www.bigdata-startups.com/abc-big-data-glossary-terminology External


extract, transform, and load (ETL) - A process used in data warehousing to prepare data for use in reporting or analytics.

[Category=Big Data ]

Source: DataInformed, 30 October 2013 08:56:15, http://data-informed.com/glossary-of-big-data-terms/ External


ETL - Extract, Transform and Load, is really all about using software data tools to get data (a dataset) from one or more databases, manipulating it using rules or actions e.g. reformat, merge, split, de-dupe the data and then uploading the transformed results to another database. You could of course update the original database if you needed to.

[Category=Data Cleansing ]

Source: Datawand, 25 December 2013 09:09:47, http://www.datawand.com/glossary/ External


Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: dqglossary@grcdi.nl