To run Database Configuration manually with a Cloud Connect database driver, complete the following steps:
- If Database Configuration does not launch automatically, click Start, All Programs, Oracle - Primavera P6, P6 Professional <release level>, P6 Professional <release level> Help and Tools, Database Configuration.
- On the Database Configuration wizard, click Add to create a new alias.
- In the Database alias field, enter a name for the new alias.
- In the Driver type field, select P6 Professional Cloud Connect.
Note: Select P6 Professional Cloud Connect only if you installed P6 Professional Cloud Connect in P6 EPPM to set up a remote method of access to connect to the EPPM Oracle database and the P6 APIs. P6 Professional Cloud Connect is not supported with SQL Server.
- In the Connection String field, enter the connection string to your database in the format
<database name>@http://<host name>:<port number>/p6cloudconnect.For example,
p6cloud@/http://p6server.nesbidcorp.com:1234/p6cloudconnectNote: Contact your P6 EPPM administrator to obtain the URL for P6 Professional Cloud Connect.
- In the Read Timeout field, enter the number of seconds to wait for a response to a query sent to the Cloud Connect database. Oracle recommends a value of 900.
- If P6 Professional Cloud Connect service uses SAML, select the Use SAML SSO option.
- If your organization allows the use of a local cache database, to improve performance with the P6 Professional Cloud Connect service, select the Enable Client-side Cache option.
- In the Enter public login Information section, enter your public login information that was defined by your administrator.
- Click Test to test the database connection. If the connection is successful, click Save. If the connection is not successful, revise the database connection information you provided.