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. ...
Get Microsoft Identity Manager 2016 Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
