Software  >   Systems Software  >   Database Management Software  >  

ETL (Software)

RSS Feed    Add to Google    Add to My Yahoo!
ALSO CALLED: Data Extraction Software, Database Extraction Software, Extract Transform Load
DEFINITION: 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  … 
Definition continues below.
ETL (Software)White Papers (View All Report Types)
26 - 30 of 30 Matches Previous Page  |  Next Page
Complex Data: A New Challenge for Data Integration
sponsored by Informatica
WHITE PAPER: A data warehouse isn't the whole truth without data from complex sources. Learn how complex data gives analytic applications greater accuracy and enables new operational applications.
Posted: 29 Nov 2007 | Published: 01 Nov 2007

Informatica

Comprehensive Data Warehousing & BI Solution with Oracle Database 11g
sponsored by Oracle Corporation
WHITE PAPER: This white-paper provides an overview of Oracle Database 11g's capabilities for data warehousing, and discuses its key features and technologies. Discover how to integrate information, perform fast queries, scale to very large data volumes, and more.
Posted: 15 Oct 2007 | Published: 01 Oct 2007

Oracle Corporation

Gartner Magic Quadrant for Data Integration Tools, 2006
sponsored by Pervasive Integration
WHITE PAPER: Gartner's Magic Quadrant for data integration tools evaluates vendors offering broad data integration capabilities through an integration platform. Discover the ranking of capabilities and functionality, including data quality and profiling.
Posted: 18 Sep 2007 | Published: 22 Nov 2006

Pervasive Integration

Mitigate Business Intelligence Project Risks With Rule-Based Audits and Proofs-of-Concept
sponsored by Syncsort
WHITE PAPER: Learn about two methods for minimizing the risk associated with business intelligence (BI) iterations: Rule-Based Audits and Proof-of-Concepts. Implemented together, they represent a continuum of risk mitigating techniques.
Posted: 19 Mar 2007 | Published: 01 Mar 2007

Syncsort

Speeding ETL Processing in Data Warehouses
sponsored by Syncsort
WHITE PAPER: This white paper discusses how two operations in particular -- joins and aggregations -- play an integral role during preprocessing as well in manipulating and consolidating data in a data warehouse.
Posted: 19 Mar 2007 | Published: 01 Mar 2007

Syncsort
26 - 30 of 30 Matches Previous Page    1 2    Next Page
 
ETL (SOFTWARE) DEFINITION (continued): …  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 ETLTo explore how ETL is used in the enterprise, here are some additional resources:ETL … 
ETL (Software) definition sponsored by SearchDataManagement.com, powered by WhatIs.com an online computer dictionary

About TechTarget:

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

All Rights Reserved, Copyright 2000 - 2014, TechTarget | Read our Privacy Statement