Prerequisites to Sync Unifier Cloud and On-Premises Data

  1. Download sync-client.zip from the Primavera Portal landing page.
  2. Create an empty Unifier database (target) on an Oracle 12c database instance.

    If there is no existing target database, create an empty Unifier database using the unifier_sys_stg_tables.sql following the instructions provided in the SQL script. The unifier_sys_stg_tables.sql is located in sync_client.zip.

  3. Connect to the target Unifier schema with sys user and run the following command

    grant select on sys.GV_$TRANSACTION to <Target unifier schema>;

  4. Run auditing_schema_changes_unifier.sql in the Unifier target schema. The script is located in sync_client.zip.
  5. Contact Cloud Support to:
    • Request server sync to be configured in the cloud.
    • Get details of the URL to access Weblogic sync server and it's authentication information.
    • Get the property values for sync.name and sync.number given in client_send.properties while configuring server.
  6. Set JAVA_HOME to Java 1.8.

Last Published Friday, July 5, 2024