Service Manager transfers the data to the data mart using an ETL process as described in the introduction of this chapter. The individual steps of the ETL process are implemented as data warehouse jobs that are run by the Service Manager Data Warehouse management server.
The entire ETL process cycle to transfer new data or data changes from the operational database to the data mart can take up to 1 hour to complete.
While this is okay for most common reporting needs, it can be an issue when you would like to get real-time information from Service Manager, such as the number of currently open and unassigned incidents.
In this recipe, we will access the Service Manager operational database to retrieve ...