internet.com
You are in the: Small Business Computing Channelarrow View Sites +
Small Business Technology
» ECommerce-Guide | Small Business Computing | Webopedia | WinPlanet |  »Close
Webopedia.com
Enter a word for a definition... ...or choose a computer category.
 
 

menu
   Home
   Term of the Day
   New Terms
   Pronunciation
   New Links
   Quick Reference
   Did You Know?
   Categories
   Tech Support
   Webopedia Jobs
   About Us
   Link to Us
   Advertising
  

talk to us
   Submit a URL
   Suggest a Term
   Report an Error

internet.com
Developer
International
Internet Lists
Internet News
Internet Resources
IT
Linux/Open Source
Personal Technology
Small Business
Windows Technology
xSP Resources
Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers
commerce
  Be a Commerce Partner
 
 
 
 
 
 
 
 
 
 
 
 
 
 

ETL
Last modified: Wednesday, December 12, 2001 

Short for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database.
  • Extract -- the process of reading data from a database.
  • Transform -- the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database. Transformation occurs by using rules or lookup tables or by combining the data with other data.
  • Load -- the process of writing the data into the target database.

ETL is used to migrate data from one database to another, to form data marts and data warehouses and also to convert databases from one format or type to another.

E-mail this definition to a colleague

Sponsored listings

Exeros: Data Integration Software - Data integration software automatically discovers, generates, documents, and validates source-to-target data transformations between datasets.


For internet.com pages about ETL . Also check out the following links!

Related Links

related categories

Databases

related terms

DAM

data mart

data migration

data warehouse

database

database management system


webopedia
Give Us Your
Feedback


Shopping
ETL Products
Compare Products,Prices and Stores

Shop by Category:
Home Furnishings
387 Store Offers

Monitors
15 Model Matches



JupiterWeb networks:

internet.comearthweb.comDevx.com graphics.com

Search JupiterWeb:

Jupitermedia Corporation has two divisions:
Jupiterimages andJupiterWeb


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Jupitermedia Corporate Info | Newsletters | Tech Jobs | Shopping | E-mail Offers