The two main components of Microsoft System Center Reporting Manager (SCRM) 2006 are a data warehouse and a reporting server built on Microsoft SQL Server 2005. The data warehouse contains data transferred and aggregated from SMS 2003, MOM 2005, and business context data, such as Active Directory. The reporting server delivers analytical and historical reports from that data.
The SCRM Administrator console is a Microsoft Management Console that is used to manage the SCRM 2006 data warehouse and data sources. The SCRM Administrator console allows you to add data sources, manage DTS jobs such as database grooming and data source synchronization, and import report collections.
SCRM reports are viewed using SQL Server 2005 Reporting Services. SQL Server 2005 Reporting Services is a server-based reporting platform that you can use to create and manage tabular, matrix, graphical, and freeform reports that contain data from relational and multidimensional data sources.
Installing SCRM 2006
Before you begin the installation, ensure that you have sufficient database and disk storage for installing and using SCRM 2006. For information about the database requirements for running SCRM 2006, see SCRM 2006 Database Requirements. For important security information, read SCRM 2006 Security Considerations. Read SCRM 2006 Hardware and Software Requirements for information about the hardware and software requirements that are required for SCRM 2006.
Installing and configuring SCRM 2006 requires the following four steps.
1. Install SCRM
You can install SCRM 2006 by using the installation wizard or the command line. For further information, see How to Install SCRM 2006 Using the Installation Wizard and How to Install SCRM 2006 Using the Command Line.
2. Add SCRM Data Sources
After installing SCRM 2006, you use the SCRM Administrator to add and configure data sources. SCRM 2006 collects data from SMS 2003 and MOM 2005 and can be configured to collect business context data from other sources, such as Active Directory.
For information about adding and configuring MOM data sources, see How to Add a MOM Data Source Using the Add Data Source Wizard and How to Configure a MOM Server as an SCRM Data Source.
For information about adding and configuring SMS data sources, see How to Add an SMS Data Source Using the Add Data Source Wizard and How to Configure an SMS Server as an SCRM Data Source.
If your SMS Server is in a domain untrusted by the SCRM server's domain, see How to Configure an SMS Server in an Untrusted Domain.
If you need to import custom hardware inventory data defined by SMS_DEF.MOF extensions from SMS, see the SCRM Importing Custom SMS Hardware Information to SCRM 2006 Whitepaper (http://go.microsoft.com/fwlink/?LinkId=60746).
For information about adding other data sources, see the Loading Business Context Data Whitepaper (http://go.microsoft.com/fwlink/?LinkId=62109).
3. Synchronize SCRM Data Sources
After a data source is added, a DTS job must be configured to synchronize the source data with the SCRM data warehouse. For more information, see How to Synchronize SCRM 2006 Data Sources.
4. Import SCRM Report Collections
To make SCRM 2006 reports available for use, you need to import the SCRM reports collection. For more information, see How to Import SCRM 2006 Report Collections.
Viewing a SCRM Report
After you have installed and configured SCRM and synchronized your data sources, you can view SCRM Reports. See How to View an SCRM 2006 Report.
For more information about using SCRM 2006 reports, see the SCRM 2006 Report Users Guide (http://go.microsoft.com/fwlink/?LinkId=62111).
Customizing SCRM Reports
The SCRM 2006 presentation database views allow you to customize SCRM reports. For more information, see the SCRM 2006 Customizing Reports Guide (http://go.microsoft.com/fwlink/?LinkId=62110).
For troubleshooting information, see http://go.microsoft.com/fwlink/?LinkId=62112.