ETL Explained

ETL is short for Extract, Transform and Load: these three functions are combined to pull data from a source and place it in a destination database.

• Extract: the process of reading data from a source.
• 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 business rules or lookup tables or by combining the data with other data.
• Load: the process of writing the data into the target database.

Cúram Business Intelligence and Analytics uses ETLs to move and transform data from the On-Line Transaction Processing (OLTP) data source to the Cúram Business Intelligence data sources. As explained previously, data is moved from application to the staging data storage, on to the Central Data Warehouse (CDW), and then is pushed out to the data marts where it is used for viewing\reporting purposes.