Extract, Transform, Load (ETL)

From P-20W+ Community of Innovation Wiki
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).