Prerequisites to Sync P6 Cloud and On-Premises Data

Before proceeding with the sync setup, choose one of the following:

Initial Sync is recommended for only small databases where number of Projects is less than 100. Otherwise, choose Database dump restoration and Incremental Sync.

Initial P6 Sync Prerequisites

  1. Create an empty P6 database (Target) on an Oracle 12c database instance.
  2. Contact Oracle Support to:
    • Request Server sync to be configured in the cloud and get details of URL to access WebLogic Sync server and its authentication information. Also get the property values for sync.name and sync.number given in the client_send.properties file while configuring the server.
    • Ensure that the optin.project_mode property is set to 'PX' in the client_send.properties file.
  3. Set JAVA_HOME to the supported version. For more details see client Requirements document.

Database Dump Prerequisites

  1. Contact Oracle Support to request for backup dump file of your source P6 database.
  2. Import the provided P6 source admuser database dumpfile in P6 Target database (on-premises).
  3. Contact Oracle Support:
    • Request Server sync to be configured in the cloud and get details of URL to access Weblogic Sync server and its authentication information. Also get the property values for sync.name and sync.number given in the client_send.properties file while configuring server.
    • Ensure that the optin.project_mode property is set to INCRPX' in the client_send.properties file.
  4. Set the JAVA_HOME to the supported version. For more details see client Requirements document.

Last Published Friday, July 5, 2024