Cobra supports direct integration with Microsoft Project (MSP) Server. You must perform a series of steps to set up the integration.
The setup steps require that you have access to SQL Server Studio and the MSP Server database.
Attention:
- For more information, see "Configuring Microsoft Project Server for Integration" in the
Deltek Cobra Installation Guide.
- To see the list of the supported and compatible versions, see "Software Requirements" in the
Deltek Cobra Installation Guide.
To configure the MSP Server database to support integration with Cobra:
-
Using the Microsoft SQL Server Management Studio, connect to the SQL Server with MSP Server setup.
-
Once connected, expand the Database folder and look for the PWA database.
Note: The database name usually defaults to
ProjectWebApp.
-
Open the
MSP_Server_SQLServer.sql script located in the Cobra application script subfolder.
For standalone deployment, the default installation folder is: C:\Program Files\Deltek\Cobra\Scripts\SQLServer\Create.
For client/server and n-tier deployments, you can find the script in the Cobra installation folder on the server.
-
Edit the script.
- Replace all occurrences
[PWA_Reporting]
with
[<Project Web App Database Name>]
(4 occurrences).
- Replace all occurrences
[PWA_Published].[dbo]
with
[pjpub]
(103 occurrences)
- Replace all occurrences of
[PWA_Published] with
[<Project Web App Database Name>]
(5 occurrences).
- Replace all occurrences of
[dbo] with
[pjrep]
(48 occurrences).
Make sure the square brackets around the database names in the script are also replaced.
-
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.