Changing Database Connection Settings for P6 Professional

Previous TopicNext TopicContents

To configure or change the database connection for P6 Professional:

  1. From the client computer’s desktop, click Start, then choose Programs, Oracle - Primavera P6, P6 Professional <release_level>, P6 Professional <release_level> Help & Tools, Database Configuration.
  2. On the Select or Create Alias dialog box, select values for the following fields:
    1. In the Database alias field, enter a new alias. For example, PMDB.
    2. In the Driver type field, select the driver type of the database from the following options:
      • Oracle

        Proceed to the Configure ORACLE Connection dialog box.

      • Microsoft SQL Server / SQL Express

        Note: For information about the Microsoft SQL Server / SQL Express driver type, see the P6 Professional Administrator's Guide for Microsoft SQL Server Database Guide.

      • Primavera Compression Server

        Note: For information about the Primavera Compression Server driver type, see the P6 Compression Server Administrator's Guide.

      • P6 Professional Cloud Connect

        Choose this driver only if you have installed P6 Professional Cloud Connect in the P6 EPPM suite to set up a remote method of access to connect to the EPPM Oracle database and the P6 APIs. Select this driver to connect to the P6 Professional Cloud Connect server. Proceed to the Configure P6 Professional Connect Server dialog box.

  3. Enter the new database connection settings:
    1. For an Oracle Database:
      1. On the Configure ORACLE Connection dialog box, enter the new database connection settings.
      2. Type the Oracle EZCONNECT string; for example, //server name:listen port/service name. If using the TNSNAMES file, type the Oracle database name.

        Note: "//" is mandatory for API applications like Update Baseline, XML Export/import, and Schedule Comparison.

    2. For a Microsoft SQL Server database:
      1. On the Configure SQL Server Connection dialog box, enter the new database connection settings.
      2. Type the database host name and database name. The host name is the name of the computer or IP address where Microsoft SQL Server is installed, along with the port number, for example localhost, 1733. The database name was specified when the database was created; for example, PMDB.
    3. For a P6 Professional Cloud Connect database:
      1. On the Configure P6 Professional Cloud Connect Server dialog box, in the Database field, enter the P6 Web BRE database alias name.
      2. In the URL field, enter the case-sensitive URL for the P6 Professional Cloud Connect service.

        Note: Contact your P6 EPPM administrator to obtain the URL for P6 Professional Cloud Connect.

  4. On the Enter Public Login Information dialog box, enter your public login information that was defined by your administrator.
  5. On the Validate Database Connection dialog box, review the settings and click Next to test the database connection.
  6. If the connection was not successful, click Back to revise the database information.

    If the connection was successful, click Finish to complete the database connection configuration.

  7. Click Finish to complete the installation.

Tips

Related Topics

About the Database Configuration Wizard for P6 Professional



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library