Configure Cobra to Work with Microsoft Project Server

Cobra supports direct integration with Microsoft Project (MSP) Server. You must perform a series of steps to set up the integration.

The set-up steps require that you access to SQL Server Studio and the MSP Server database.

Attention: Refer to the current Cobra release notes to see the supported versions of Microsoft Project Server.

To configure the MSP Server database to support integration with Cobra, complete the following steps:

1. Using the Microsoft SQL Server Management Studio, connect to the SQL Server with MSP Server setup.
2. Expand the Databases folder and look for the PWA Reporting and PWA Published databases:

   • PWA_Reporting_<UID>

   • PWA_Published_<UID>

   The database name usually contains a unique ID (UID) similar to the following: PWA_Published_33DB2809_4292_472C_BEED_9634BBB374E7.
3. Take note of the names of the databases. Copy the names of the databases to a text editor, such as Notepad.
4. Open the script called MSP_Server_SQLServer.sql, located in the Cobra application script subfolder. For standalone deployment, the default installation folder is: C:\Program Files\Deltek\Cobra\Scripts. For client/server and n-tier deployments, you can find the script in the Cobra installation folder on the server.
5. Edit the script by replacing all occurrences of:

   • PWA_Reporting with the name of your Reporting database (2 occurrences)

   • PWA_ Published with the name of your Published database (104 occurrences)

   Keep the square brackets around the database names.
6. Run the script against the MSP Server database. If the scripts complete successfully, the MSP Server databases are ready to run the Cobra Integration using MSP Server. You can define the connection information to the MSP Server on the New Connection dialog box of the Integration wizard.