Sync Client Installation Prerequisites

Complete the following prerequisites to install the sync client application for a PX - PX initial sync.

Prerequisites for PX - PX Initial Sync

Ensure the following:

  1. A P6 database (source) with data is created on Oracle 12c database instance.
  2. In P6 application, if you have a user name called admin, you will need to rename it as this user name is used during Sync setup.
  3. Enable full auditing to get incremental changes by executing the following procedure in P6 source database by connecting as ADMUSER.

    exec auditing_enable(null,3);

  4. Contact My Oracle Support and request configuring the sync server in the cloud . Also obtain the URL to access the sync server.
  5. Create a user in the Primavera Administration Application and assign the Primavera Data Sync Production role to authenticate the sync server.
  6. For PX Sync, execute SQL scripts before installation as follows:
    1. Unzip the sync_client.zip and navigate to the Scripts folder.
    2. Open the audit_schema_changes_px.sql file.
    3. Replace 'ADMUSER' in the .sql file with the source admuser schema name (only when source schema name is not ADMUSER).
    4. Execute the audit_schema_changes_px.sql script by connecting as source admuser schema. For example, ADMUSER.
    5. Connect to database having source P6 schema as a system user having DBA privileges and run the following command:

      grant create trigger to <On-Premise P6 admuser schema>;

  7. Execute the auditing_enable_px.sql script by connecting as source p6 schema user. For example, ADMUSER.


Last Published Friday, December 8, 2023