Word of the Day: extract, transform, load (ETL)

Word of the Day Daily updates on the latest technology terms |September 28, 2017

extract, transform, load (ETL) In database management, extract, transform, load (ETL) is a programming tool that consists of three separate functions. ETL is often used to acquire a temporary subset of data for reports or other purposes. First, the extract function reads data from a specified source database and removes 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 - and converts it to the desired state. Finally, the load function writes the resulting data (either all of the subset or just the changes) to a target database, which may or may not previously exist. In addition to acquiring a data subsets for reports, ETL is also used to migrate data from one database to another and populating data warehouses. 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. Quote of the Day "Over the years, ETL tools have evolved in several key areas, including development, operational processing and integration functionality." - Rick Sherman   Trending Terms fixed data data warehouse raw data data mart extract, load, transform change data capture   Learning Center Bank sees ETL processes evolve from IT to front-line users ETL processes that resided in IT are morphing and migrating to business groups as data wrangling and self-service gain more use for analytics. Data integration platforms take users beyond ETL software Expert Rick Sherman examines how data integration platforms have evolved to meet the growing demands for data that's ready for business analysis. Spark brings value to big data analytics and ETL processes Spark is earning the interest of enterprise architects for unifying data stored across the enterprise as an open source approach for better ETL processes. What are key features for choosing the best ETL tools for your needs? There's a set of core functions that most ETL software vendors support -- and that buyers should look for when evaluating and selecting the best ETL tools. How to justify the purchase of a data integration tool With big data everywhere, data integration is more vital than ever. Explore how a data integration tool can help address your enterprise's needs. Quiz Yourself A data ______ is generally controlled by a single department of an organization, such as sales or finance. a. warehouse b. mart Answer   Stay In Touch For feedback about any of our definitions or to suggest a new definition, please contact me at: mrouse@techtarget.com   Visit the Word of the Day Archives and catch up on what you've missed!   FOLLOW US About This E-Newsletter This e-newsletter is published by the TechTarget network. To unsubscribe from Whatis.com, click here. Please note, this will not affect any other subscriptions you have signed up for. TechTarget, Whatis, 275 Grove Street, Newton, MA 02466. Contact: webmaster@techtarget.com Copyright 2016 TechTarget. All rights reserved.