To configure or change the database connection for P6 Professional proceed as follows:
From the client computer’s desktop, click Start, then choose Programs, Oracle - Primavera P6, P6 Professional R8.x, P6 Professional R8.xHelp & Tools, Database Configuration.
On the Select or Create Alias dialog box, select values for the following fields:
In the Database alias field, enter a new alias. For example, PMDB.
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 a Microsoft SQL Server Database Guide.
Primavera Compression Server
Note: For information about the Primavera Compression Server driver type, see the P6 Compression Server Administration 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.
Enter the new database connection settings:
For an Oracle Database:
On the Configure ORACLE Connection dialog box, enter the new database connection settings.
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.
For a Microsoft SQL Server database:
On the Configure SQL Server Connection dialog box, enter the new database connection settings.
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.
For a P6 Professional Cloud Connect database:
On the Configure P6 Professional Cloud Connect Server dialog box, in the Database field, enter the P6 Web BRE database alias name.
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.
On the Enter Public Login Information dialog box, enter your public login information that was defined by your administrator.
On the Validate Database Connection dialog box, review the settings and click Next to test the database connection.
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.
Click Finish to complete the installation.
Tips
PrmBootStrapV2.xml file is used regardless of the Driver type selected above.
If you create a new database alias for a module, the module’s PrmBootStrapV2.xml file is updated to reflect the change. If multiple modules are installed on one client computer, changing the database alias for one module does not affect the other modules.
If you change the database connection settings for a database alias and multiple modules share that alias to access the database, your changes affect all the modules that share the alias.
For instructions on how to configure P6 Compression Server, see the P6 Compression Server Administrator's Guide.