• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Site-Logo
Phone 703-910-2600

Ten Six Consulting

Project and Earned Value Management, Primavera P6 & Deltek Cobra & Acumen Services

703-910-2600
  • Training Classes
    • Primavera P6 Training
    • Deltek Training
    • Earned Value Management Training
    • Project Management Training
    • Open Training Class Dates
  • Scheduling Services
  • Earned Value Mgmt. Services
    • RFP Support
    • Your EVM System
    • Certification
    • Data Analysis and Reporting
    • Post Contract Support
    • Staff Augmentation
    • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
  • Tools
    • Primavera P6
      • Knowledge Transfer, Mentoring and Coaching
      • BI Publisher Services
    • Primavera Unifier
    • Deltek Cobra
      • Knowledge Transfer, Coaching and Mentoring
      • Staff Augmentation
    • Microsoft Project to Primavera P6 Conversion Services
    • Microsoft Project
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
  • Blog
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • Contact Us
  • Training Classes
    • Primavera P6 Training
    • Deltek Training
    • Earned Value Management Training
    • Project Management Training
    • Open Training Class Dates
  • Scheduling Services
  • Earned Value Mgmt. Services
    • RFP Support
    • Your EVM System
    • Certification
    • Data Analysis and Reporting
    • Post Contract Support
    • Staff Augmentation
    • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
  • Tools
    • Primavera P6
      • Knowledge Transfer, Mentoring and Coaching
      • BI Publisher Services
    • Primavera Unifier
    • Deltek Cobra
      • Knowledge Transfer, Coaching and Mentoring
      • Staff Augmentation
    • Microsoft Project to Primavera P6 Conversion Services
    • Microsoft Project
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
  • Blog
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • Contact Us

Deltek Cobra Integration with Primavera P6 – How To Guide

You are here: Home / Deltek Cobra / Deltek Cobra Integration with Primavera P6 – How To Guide

December 1, 2021 By TheCobraGuy

This article shows how to setup Deltek Cobra integration with Primavera P6. We will take you through the process, step-by-step and complete with screens shots, showing you exactly what you need to do.

Overview

In summary, the steps to setup Deltek Cobra integration with Primavera P6 are as follows:

  1. Install a recent version of Java Runtime Environment (JRE)
  2. Set your JAVA_HOME environment variable
  3. Install Microsoft SQL Server Express 2019 or later
  4. Install the SQL Server Management Studio
  5. Open the TCP/IP port for network access
  6. Run the Primavera P6 dbsetup.bat application to build a new Primavera P6 database
  7. Install Primavera P6 Professional client – if not already installed.
  8. Create an ODBC Data Source that points to the new Primavera P6 Database
  9. Create a connection to the P6 data source in Cobra’s Integration Wizard

Architecture

The basic architecture for the Deltek Cobra integration with Primavera P6 integration is setup as follows.Deltek Cobra integration with Primavera P6This article shows the steps for installing Microsoft SQL Server Express 2019 or later for a standalone database. It will then show you how to install Primavera P6 Professional and create a PPMDB database in the SQL Server P6 database. Finally, you will see how to integrate Deltek Cobra with this standalone version of P6 Professional.

Important:

You will need to obtain/download/install or confirm the presence of the following software on your workstation:

  • Java Runtime Environment (JRE) Version 8, Update 51 or later
  • Deltek Cobra 8.3 or later
  • Deltek Cobra HotFix#n (the latest Cobra Hotfix file from Deltek)
  • Microsoft SQL Server Express 2019 media package (SQLServer2019-SSEI-Expr.exe) or earlier. Other versions will also work including 2008 R2, 2010, 2012, 2014, and 2017
  • Microsoft SQL Server Management Studio (SSMS-Setup-ENU.exe)
  • Microsoft .NET Framework 4.5 (if not already installed on your operating system)

Recommended Operating Systems

  • Microsoft Windows 7 Home or Professional (SP1)
  • Microsoft Windows 10 Home or Professional

Step 1 – Install Java

You will need a recent copy of Java Runtime Environment (JRE) installed on your machine. For example, if you are installing Primavera P6 Professional you will need Java 8 Update 51.

If you have no Java installed on your machine, follow these next steps.

  1. Download a recent version of Java 8 to your machine
  2. In the download directory right –click and run the download file as administrator (in this example, jre-8u51-windows-x64.exe).Deltek Cobra integration with Primavera P6
  3. In the User Account Control dialog, click Yes
  4. In the Java dialog, click Install
  5. In the subsequent Progress dialog, be impressed with the large number of devices that run Java while observing progress of the install
  6. In the Java Setup – Complete dialog, click Close
  7. Congrats, your machine is now the 3 billionth-and-first device using Java

Step 2 – Setup your JAVA_HOME Environment Variable

Some more antiquated software applications still use Windows Environment Variables to find out where certain files are on your particular system. Before we can run the dbsetup.bat program to build your Primavera P6 Professional database schema, we will need to tell the JRE where the Java Home directory is. These next steps will assist you with this process.

  1. Open a Windows File Explorer
  2. Locate your Java installation directory and select itDeltek Cobra integration with Primavera P6
  3. Click on the Path field at the top of the File Explorer and copy the path to the clipboard
  4. Windows 7 Users – Click on your Windows Start menu and in the Search field enter ‘Environment’
  5. In the results area at the top of the popup, click on the ‘Edit the system environment variables’ option
  6. Windows 10 Users – type ‘environment’ in the search field
  7. In the results area click on the ‘Edit the system environment variables’ option
  8. Windows 7 & 10 Users – In the resulting System Properties dialog click on the Environment Variables…
  9. In the lower ‘System Variables’ area of the Environment Variables dialog, click on the New…
  10. In the New System Variable dialog, enter JAVA_HOME in the Variable Name
  11. In the Variable Value field, paste the path to your JRE installation that you copied earlier
  12. Click OK
  13. Verify that your new environment variable has been added to the list of existing variables
  14. Close all the remaining dialogs and you are now ready to continue with the remaining setup items

Step 3 – Installing the SQL Server Database

These next steps will assist you installing a Microsoft SQL Server Express database on your workstation. In this example the SQL Express 2017 version will be installed on Windows 10. This is basically identical if you are installing the later 2019 version of SQL Server.

  1. Locate and run the Microsoft SQL Server Express installation media file you downloadedDeltek Cobra integration with Primavera P6
  2. Click Yes to the User Account Control
  3. When prompted, go with the Basic installation optionDeltek Cobra integration with Primavera P6
  4. Go with the default installation location by clicking InstallDeltek Cobra integration with Primavera P6
  5. The installer will download packages from the internet and then start the installation process. This may take a few minutes
  6. In the SQL Server Installation Center dialog, click on the ‘New SQL Server Stand-alone installation…etc.’ optionDeltek Cobra integration with Primavera P6
  7. Accept the License Terms and click Next >
  8. In the Microsoft Update dialog, click Next >Deltek Cobra integration with Primavera P6
  9. In the Install Rules dialog click Next >
  10. In the Features Selection dialog, uncheck the SQL Server Replication and Machine Leaning ServiceDeltek Cobra integration with Primavera P6
  11. Click Next >
  12. In the Instance Configuration go with the default Named Instance: SQLExpress
  13. Click Next >
  14. In the Server Configuration dialog, go with the defaults and click Next >
  15. In the Database Engine Configuration go with Mixed Mode (SQL Server authentication and Windows authentication). Then enter and confirm a password.TIP: Make a careful note of your password and keep it safe. You will need it for later access.Deltek Cobra integration with Primavera P6
  16. Click Next >.SQL Server Express 2017 will begin installing on your system. This may take several minutes
  17. When the process is complete, click Close
  18. Back in the SQL Server Installation Center, click on the Install SQL Server Management Tools
  19. In the resulting Microsoft web page, click on the Download SQL Server Management Studio 17.4
  20. When prompted by your browser, click Run
  21. When prompted by the User Account Control, click Yes
  22. Follow the instructions for the SQL Server Management Studio
  23. When done click Close

This completes the installation of your SQL Server database instance.

Step 4 – Open the SQL Server TCP/IP Port

You will now need to open the TCP/IP port for your database as this is not done by default during the SQL Express database setup.

Follow these next steps:

  1. Click on the Windows Start button and locate the SQL Server 2017 Configuration Manager that was installed as part of the previously described installation process
  2. In the Sql Server Configuration Manager, click on the SQL Server Network Configuration option and select Protocols for SQLEXPRESS
  3. Right-click on the TPC/IP option and choose
  4. When prompted click OK. We will address the restart shortly
  5. Once enabled right-click on the TCP/IP option and choose Properties
  6. In TCP/IP Properties, click on the IP Addresses
  7. Scroll to the bottom of the list
  8. In the IPA11 area, enter a TCP Port of 1433 on the last row
  9. Click OK to apply the setting and close the dialog
  10. Click OK in the prompt
  11. Back in the Sql Server Configuration Manager, click on the SQL Server Services option and then restart the SQL Server (SQLExpess) instance for your changes to take effect
  12. Close the SQL Server 2017 Configuration Manager

Step 5 – Run the Primavera P6 Professional Database Setup

This step will allow you to build a Primavera P6 Professional database schema inside your new SQL Express instance.

  1. Locate the P6 Professional Database Setup file from your Primavera P6 media download folder(s)
  2. In the P6_R1712 (or other version number) folder double-click on the dbsetup.bat file
  3. In the Primavera Database Setup Wizard, select the Install a new database and Microsoft SQL Server
  4. Click Next >
  5. In the Connection Information dialog, enter the system administrator password for your SQLExpress database instance
  6. Now add the ‘\SQLExpress’ instance name to your Database host address
  7. Click Next >
  8. In the Configure Microsoft SQL Server dialog, enter a name for your database. In this example we are calling it PPMDB
  9. Click Next >
  10. In the Create SQL Server Users dialog, enter a password for your privuser and pubuser user logins. Make a careful note of these passwords for future use
  11. Click Next >
  12. Enter an admin password. This will be your user password when login in to P6 Professional. Again make a careful note of this as you will need it every time you access P6 Professional. You also have the option to load sample data, recommended if you are planning to use this for any Ten Six Primavera training courses
  13. Click Next >
  14. The process may take a few minutes depending on your machine’s resources
  15. Click Next >
  16. Click Finish

Step 6 – Install P6 Professional

Now you will need to install Primavera P6 Professional and connect that client to your newly created database.

  1. Locate the Primavera P6 Professional install media folder
  2. Double-click on the exe file
  3. In the P6 Professional Setup dialog, go with the Default Typical option and click OK
  4. In the Ready to install Primavera P6 Professional dialog, click Install
  5. The installation will start
  6. In the next dialog, go with the Default ‘Run Database Configuration’ option and click OK
  7. This will open the Database Configuration Select the Microsoft SQL Server/SQL Express option
  8. Click Next
  9. In the Configure SQL Server Connection dialog, enter the Host Name and Database Name for your newly created database instance
  10. Enter the Public User Name and Password for your database
  11. Next
  12. In the Validate Database Connection dialog, click Next
  13. If you have entered everything correctly, you should see the Connection Successful
  14. Click Finish to close out all your Primavera P6 installation dialogs
  15. In the Start menu, locate and run the Primavera P6 Professional
  16. In the Login dialog, enter the Admin password you created during the database setup process
  17. The first time you access your new P6 Professional database you will be prompted to provide an industry setting. Click OK
  18. In P6 Professional, click on the Admin | Admin Preferences…
  19. In the Admin Preferences dialog, select the Industry tab and click on one of the industry radio buttons
  20. Click Close to save the changes
  21. Click OK to the prompt

You Primavera P6 installation is now ready for use.

Step 7 – Install Deltek Cobra

Now we will need to setup Deltek Cobra as a standalone on this machine. Again we will be using the same instance of Microsoft SQL Server 2017.

  1. Open SQL Server Express Management Studio
  2. In the Object Explorer, right-click on the Databases option and select New Database…
  3. In the New Database dialog, enter a database name of COBRA8
  4. Click OK to create the new database
  5. Now we are ready to install Deltek Cobra
  6. Locate the Deltek Cobra 8.3 (or later) media folder
  7. Double-click on the exe file
  8. Allow the program to make changes to your systemDeltek Cobra integration with Primavera P6
  9. In the Deltek Cobra Installation Wizard, click Next >Deltek Cobra integration with Primavera P6
  10. Accept the license terms and click Next >Deltek Cobra integration with Primavera P6
  11. In the dialog, enter your name, company and the serial number provided by Deltek and click Next >
  12. Enter a valid license number and then click Next >Deltek Cobra integration with Primavera P6
  13. Click Next >
  14. Select the Stand-AloneDeltek Cobra integration with Primavera P6
  15. Click Next >
  16. Select the Microsoft SQL ServerDeltek Cobra integration with Primavera P6
  17. Click Next >
  18. In the Database Server dialog, enter the particulars for your SQL Server instance as shown in the example belowDeltek Cobra integration with Primavera P6
  19. Click Next >
  20. Select the ‘Automatically run scripts during the installation’ option. This will create the required Cobra tables in your new databaseDeltek Cobra integration with Primavera P6
  21. Click OK at the prompt dialogDeltek Cobra integration with Primavera P6
  22. Click Next in the Customer Experience Improvement ProgramDeltek Cobra integration with Primavera P6
  23. Click Next to start copying installation filesDeltek Cobra integration with Primavera P6
  24. You can track the progress in the Setup Status Deltek Cobra integration with Primavera P6
  25. When the process is complete, click the FinishDeltek Cobra integration with Primavera P6
  26. Deltek Cobra will now be installed on your system. Run the program from the Start menu to test your installation. Note the default user and password for Deltek Cobra are: SYSADMIN and passwordDeltek Cobra integration with Primavera P6

Step 8 – Setup an ODBC Data Source that points to the new Primavera P6 Database

The next step in this process is to setup an ODBC data source so that other systems, such as Cobra can access the database for integration.

  1. In the Windows search field, type ‘data source’ and click on the resulting Set up ODBC data sources option in the list. Select the appropriate 32-bit or 64-bit depending on your system. If offered both, select 64-bitDeltek Cobra integration with Primavera P6
  2. In the resulting dialog, select the User DSN
  3. Click on the Add buttonDeltek Cobra integration with Primavera P6
  4. In the Create a New Data Source to SQL Server dialog, enter a name and description for your data source
  5. Enter the server name in the Server: This is typically the PC name \ instance name. In this example: DESKTOP-5OC3F3N\SQLEXPRESSDeltek Cobra integration with Primavera P6
  6. Click Next >
  7. Enter the login credentials you setup during the SQL Server installationDeltek Cobra integration with Primavera P6
  8. Click Next >
  9. Check the ‘Change to default database to:’ option to the PPMDB database you created for P6Deltek Cobra integration with Primavera P6
  10. Click Next >
  11. Go with the defaults and click FinishDeltek Cobra integration with Primavera P6
  12. Click on the Test Data Source…Deltek Cobra integration with Primavera P6
  13. Verify that the data source is working correctly. If not go back and verify your settingsDeltek Cobra integration with Primavera P6
  14. Click OK
  15. Close the Data Source

This data source will now be available in the Oracle Primavera integration wizard.

Step 9 – Create a connection to the Primavera P6 data source in Deltek Cobra

Now all that remains to do is create a connection to the Primavera Data Source in Cobra’s integration wizard.

  1. In Deltek Cobra, click on the Integration
  2. Click on the Primavera button
  3. With ‘Create a new configuration’ selected, click Next >Deltek Cobra integration with Primavera P6
  4. In Connection Selection click NewDeltek Cobra integration with Primavera P6
  5. In the New Connection dialog, Enter a name for your connection
  6. Select the Data source: radio button and select your Primavera Data SourceDeltek Cobra integration with Primavera P6
  7. Enter a User name: and Password:. This is the same ‘sa’ username and password you use to login to the SQL Server database instanceDeltek Cobra integration with Primavera P6
  8. Click the Test button to verify that the data source is workingDeltek Cobra integration with Primavera P6

At this point, you will need to create a project in Deltek Cobra and its IMS in Primavera P6. Then you can use the Deltek Cobra integration with Primavera P6.

The Deltek Cobra integration with Primavera P6 process is explained in detail in the our Deltek Cobra Fundamentals training class available for online, onsite and public classes.

Primary Sidebar

  • This field is for validation purposes and should be left unchanged.
  • Facebook
  • LinkedIn
  • Twitter

Categories

  • Deltek Acumen
  • Deltek Cobra
  • Earned Value Mgmt
  • Microsoft Project
  • PMO
  • Primavera P6
  • Project Management
  • Risk Management
CONTACT US

Footer

Upcoming Classes

Primavera P6 Professional Fundamentals
Primavera P6 EPPM Fundamentals
Primavera P6 EPPM Administrator
Primavera P6 BI Publisher Fundamentals
Deltek Cobra Fundamentals
Deltek Cobra Advanced
Deltek Acumen Fuse
Deltek Acumen Risk

  • This field is for validation purposes and should be left unchanged.
  • Facebook
  • LinkedIn
  • Twitter
  • Consulting Services
  • About Ten Six
  • Contact Us
  • Blog

Copyright © 2023 Ten Six Consulting, LLC · 703.910.2600

  • Training Classes
    ▼
    • Primavera P6 Training
    • Deltek Training
    • Earned Value Management Training
    • Project Management Training
    • Open Training Class Dates
  • Scheduling Services
  • Earned Value Mgmt. Services
    ▼
    • RFP Support
    • Your EVM System
    • Certification
    • Data Analysis and Reporting
    • Post Contract Support
    • Staff Augmentation
    • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
  • Tools
    ▼
    • Primavera P6
      ▼
      • Knowledge Transfer, Mentoring and Coaching
      • BI Publisher Services
    • Primavera Unifier
    • Deltek Cobra
      ▼
      • Knowledge Transfer, Coaching and Mentoring
      • Staff Augmentation
    • Microsoft Project to Primavera P6 Conversion Services
    • Microsoft Project
      ▼
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
  • Blog
    ▼
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • Contact Us