Extract, Transform, Load (ETL)

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).