Database Reference
In-Depth Information
System Center Service Manager
System Center Service Manager contains a Data Warehouse database that you can use to
gain insight into the data stored in Service Manager. Service Manager periodically transfers
data that is stored in the operational database to the Service Manager Data Warehouse data-
bases through a process called
extract, transform, and load
(
ETL
). The processes re-
quired to keep the data in the Data Warehouse in sync with the operational database are
controlled by the Service Manager Data Warehouse Management Server role, as shown in
the following image:
The reasons to transfer data to the Service Manager Data Warehouse databases are as fol-
lows:
• Offload data from the Service Manager operational database to improve perform-
ance
• Provide long-term storage of historical data stored in Service Manager
• Optimize and provide data for reporting
The
DWDataMart
database is the database used for all reporting needs. In addition, Ser-
vice Manager comes with a set of predefined OLAP cubes to facilitate advanced analysis of
data. An OLAP cube is a multidimensional data structure that is optimized to aggregate and
analyze a large amount of data while also allowing access to the most granular information.
The SCSM Data Warehouse leverages Microsoft SQL Server Analysis Services to provide
OLAP cubes to end users.
With both the
DWDataMart
database and the OLAP cubes, Service Manager provides
powerful means to create simple reports, as well as gain advanced insight into the data by
analyzing it from multiple perspectives.
