Cobra 8.3 Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

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:

  1. Using the Microsoft SQL Server Management Studio, connect to the SQL Server with MSP Server setup.
  2. Once connected, expand the Database folder.
    • If you are configuring MSP 2013, 2016, or 2019 server, look for the PWA database.
      Note: The database name usually defaults to ProjectWebApp.
    • If you are configuring MSP 2010 server, look for the following and take note of the names of the databases:
      • PWA_Reporting_<UID>
      • PWA_Published_<UID>
      Note: The database name usually contains a unique ID (UID) similar to the following: PWA_Published_33DB2809_4292_472C_BEED_9634BBB374E7.
  3. 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.

  4. Edit the script.
    • If you are configuring MSP 2016 or MSP 2019, do the following:
      • 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).
    • If you are configuring MSP 2013, do the following:
      • Replace all occurrences of [PWA_Reporting] with [<Project Web App Database Name>] (4 occurrences) .
      • Replace all occurrences of [PWA_Published].[dbo] with [<Project Web App Database Name>].[pub] (103 occurrences).
      • Replace [PWA_Published] with [<Project Web App Database Name>] (5 occurrences).
    • If you are configuring MSP 2010, do the following:
      • Replace all occurrences of [PWA_Reporting] with the full name of the Reporting database (4 occurrences).
      • Replace all occurrences of [PWA_Published] with the full name of the Published database (108 occurrences).
      Note: Make sure the square brackets around the database names in the script are also replaced.
    Make sure the square brackets around the database names in the script are also replaced.
  5. Run the script against the MSP server database.
  6. 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.