About data synchronization

Reports and dashboards use the data that is stored in the reporting database. The data that is required for reports and dashboards is synchronized with the production database using the synchronization job. The scheduled reporting database synchronization job is located in the Job Management view.

The prerequisite for the Scheduled Reporting Database Synchronization Job requires SQL Server 2005 Integration Services (SSIS) SP2 to be installed.

The synchronization job operates in the following modes:

The automatic mode synchronizes data between the production and reporting databases after the completion of selected jobs. You can select the jobs in the Settings > General > System Configuration > Reporting Synchronization.

The scheduled synchronization job can be set to start at a specific time. You can request an administrator to schedule a synchronization job to run now. Only administrators run the synchronization job. You should run a synchronization job before you schedule a report or dashboard.

More Information

About the Report Management jobs

Synchronizing the reporting database