The reporting database is hosted by a Microsoft SQL Server. The reporting database is periodically synchronized with the data that is stored in the production database. In addition, the database stores data specific to individual dashboards or reports. The DPS Reporter monitors the synchronization of data between the production database and the reporting database.
The reporting database requires Microsoft SQL Server 2005 SP2. The Control Compliance Suite requires a single reporting database. The reporting database can share a host server with the Control Compliance Suite Directory, or it can be hosted by a dedicated server. The reporting database can be hosted on the same SQL Server as the production database, or on another SQL Server.
The reporting database also needs to be accessible to an SQL Server with Integration Services (SSIS) installed. SSIS can be installed on the same server that hosts the reporting database, or SSIS can be installed on another SQL Server. Normally, SSIS should be installed on the server that hosts the reporting database. The Control Compliance Suite requires SSIS SP2.