The SCSM ETL process
The SCSM ETL process is broken into several steps, which we will outline here. To understand this, we will first start with the MIM service. As we have discussed previously in this chapter, we executed the initial job and watched this job get created in the portal. Now, we will explain what is happening under the hood so that it can help you troubleshoot and manage the reporting system.
The steps to move the data are defined as follows:
Initial: This process reads data directly from the Service Objects database.
Initial-Partial: This process allows for the movement and configuration of the schema attribute.
Incremental: This process runs every 8 hours, or as set by the SQL agent job. This ETL job reads the export log table only.
When you first kick off reporting the Initial job, this job extracts data from the [fim].[Objects]
table. So, if you're just turning on Reporting but you have had MIM up for a while and have a large set of data, your initial sync could take a bit...