Option 1: Installing Sync Client in the User Interface Mode

To install the sync client using the Sync Client user interface application:

Unzip the sync_client.zip file and enter the resulting sync_client directory.
$ unzip sync_client.zip -d sync_client

$ cd sync_client

or

Unzip the sync-client.zip file available in the present working directory and enter the resulting sync-client directory.

$ unzip sync-client.zip

$ cd sync-client
If on a Unix or Linux system, set the executable flag on the shell scripts
$ chmod u+x *.sh
You will need to start the sync client's server, but before that add proxy settings in startserver.sh file as given below.
java -jar ../start.jar -Dhttps.proxySet=true -Dhttps.proxyHost=<Proxy HostName> -Dhttps.proxyPort=<Proxy Port> -Dhttp.proxySet=true -Dhttp.proxyHost=<Proxy HostName> -Dhttp.proxyPort=<Proxy Port> -Dapp.name=client-sync > /dev/null &

Contact Oracle Support for information on the Proxy HostName and Proxy Port details which were used to set up the server.

Update the startserver.sh file and start the Jetty server with following command

$ ./startserver.sh -u
When prompted enter the syncadmin password and confirm the password when prompted to re-enter. Jetty server starts running on port 8511
The server log file is available in log/server.log
Open a browser and enter the following URL to launch Sync Client UI app:
http://<hostname>:8511/client-DataSync/config.xhtml

where the IP address or <hostname> is that of the machine that has the Jetty server running.
In the DACS Client Utility page, enter the following information in each section:
Sync Properties Section
1. In the Sync Mode field, select CLIENT from the drop-down list.
2. In the Sync Client field, select SENDER from the drop-down list.
3. In the Sync Name field, enter the value, ds_pxsync, for PX Sync (P6 + PX data).
4. In the Sync Number field, enter the value, 4, for PX Sync.
Database Info Section
1. In the Database Host field, enter the host name or IP address of the machine hosting the P6 source database.
2. In the Database Port field, enter the port number for the Oracle instance on which P6 source database is created.
3. In the Database Service Name field, enter the service name of the Oracle instance on which the P6 source database is created
4. In the Database Type field, based on your sync configuration, select PX from the drop-down list for a PX sync.
5. Select the Skip Schema Creation check box only when intermediate schema (starting with "T_") is already created.
Database Credentials Section
1. In the Database Schema field, enter the on-premises P6 Database schema name For PX Sync. For example, admuser.
2. In the Database Password field, enter the password for the user name provided in the Database Schema field.
3. In the Database Sync User field, enter any name starting with T_. This will be intermediate schema name and is newly created. Ensure there is no existing schema with same name on the database instance where on-premises source database is hosted.
4. In the Database Sync Password field, enter the password for the user name provided in Database Sync User field. If this schema does not exist, provide your own value. This process will create a new schema.
5. In the Database SYS User field, enter a user name having SYSDBA privileges. For example, SYS.
6. In the Database SYS Password field, enter the password for the user provided in Database Sys User field.
Database Source Server Info Section
1. In the Server Base URL field, enter the URL of the WebLogic server sync rest service you have received from Oracle Support in the format:
  http://<CloudServer Hostname>:<port>/DataSync/rest-service
2. In the Server Connect User field, enter the name of the user who has been assigned the Primavera Data Sync Production role in the Primavera Administration Application to access the cloud sync services.
3. In the Server Connect Password field, enter the password for the user provided in Server Connect User field
4. In the Project Mode field, select PX from the drop-down list to synch any project whose publication status is set to Yes.
5. In the Project Value field, enter the value, Y.
Click on the Validate Connection button to confirm the entered information.
Note: The validation process may take few minutes until which the Complete Setup button is disabled.
Upon successful validation, select the Complete Setup button.
The server creates the intermediate schema in the given database.
Upon receiving a successful completion message, click on the Start Sync button to begin the sync process.

Related Topics