ETL (Extraction, Transform and Load)

ETL is software that enables business to consolidate their disparate data while moving it from place to place, and it doesn’t really matter that the data is in different formats. The data can come from any source.

Extract function reads data from specified source database and extracts a desired data.

Transforms using business rules, lookup tables or creating combinations with other data to convert it to desired state.

Load function is used to write the resulting data to a target database.