The SCSM ETL process

The Extract, Transform and Load (ETL) process refreshes the data in the warehouse. This is logically a sequential flow of data:

• The Extract job acquires data from registered management servers

• The Transform job optimizes the data for reporting needs and shapes the data according to the defined business rules

• The Load job populates the data mart for long-term retention and access

Our problem is that there will be no data in our reports until the ETL process has done its job. If you would like to speed up that process, you can save and run the following PowerShell script on your FIM Service server:

Tip

Remember to change the $dwMachine value to the actual name of your SCSM DW server.

if (@(get-pssnapin | where-object {$_.Name -eq "SMCmdletSnapIn"} ).count -eq 0)
{
    Add-PSSnapin SMCmdletSnapIn
}

$dwMachine = "SCSM-DW"

Function WaitForId($id)
{
Write-Host ("Waiting on the job " + $id)
    do
    {
        $job = Get-SCDWJob -ComputerName $dwMachine -JobBatchId $id
      ...