Service Manager periodically transfers data that is stored in the operational database to the Service Manager Data Warehouse databases through a process called Extract Transform and Load (ETL). The processes required for keeping the data in the Data Warehouse in sync with the operational database are controlled by the Service Manager Data Warehouse Management Server role.
The ETL process is started on a scheduled interval. The first step is the extract workflow that reads new data from the operational database and writes it to the DWStagingAndConfig database. The raw data is then picked up by the transform workflow that does the required reformatting for bringing the data into the final format optimized for reporting prior to storing it in the DWRepository database. The load workflow then transfers the data to the DWDataMart database where it can be used for reporting.
The reasons for transferring data to the databases of the Service Manager Data Warehouse are to:
Offload data...