Extract, Transform, Load (ETL)

From P-20W+ Community of Innovation Wiki
Revision as of 15:28, 7 March 2023 by WendyGeller (talk | contribs) (Created page with "ETL is the process of: *Extracting data from a source such as a database, csv file, or EXCEL file. *Transforming the data if necessary (i.e., formatting to CEDS, converting number to text, performing a lookup and replacement, etc.). *Loading the data into a database or exporting to a data file (i.e., .csv, .xlsx).")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

ETL is the process of:

  • Extracting data from a source such as a database, csv file, or EXCEL file.
  • Transforming the data if necessary (i.e., formatting to CEDS, converting number to text, performing a lookup and replacement, etc.).
  • Loading the data into a database or exporting to a data file (i.e., .csv, .xlsx).
Retrieved from "http://wiki.dataaccelerator.org/index.php?title=Extract,_Transform,_Load_(ETL)&oldid=54"