The MPM Data Warehouse is a central repository for project and global data from any and all corporate locations. The consolidated data can be used for analysis and reporting.
The Data Warehouse consists of the following components:
Microsoft SQL Server — This schema is optimized for MPM data.
MPM Data Warehouse Controller — This application resides on the database server, or optionally on a separate host machine, and is responsible for managing the importation of MPM data.
MPM Data Warehouse Controller user interface — This interface is located in the MPM Project Maintenance window and is used to select and schedule project and global data for import by the Controller into the data warehouse.
Changing the Project Synchronization Retry Interval Settings