You can send project data from cloud installations of Oracle Primavera Cloud to local installations of P6 EPPM using Cloud Sync. To configure synchronization between your products, you must modify synchronization properties. Refer to the Synchronization Properties table for descriptions of synchronization property fields and values.
To synchronize data from Oracle Primavera Cloud to P6 EPPM:
- Navigate to the folder in which P6 EPPM is installed, then navigate to the /cloudsync folder.
- Open client_send.properties in a text editor of your choice and modify the following properties:
Sync Properties
sync.mode=CLIENT
sync.type=RECEIVER
sync.name=<Sync Name>
sync.number=<Sync Number>
- Note: Contact your cloud administrator to request the appropriate value for the sync.number property.
Target Database Properties
target.db.host=<P6 EPPM database schema host>
target.db.port=<P6 EPPM database port number>
target.db.service=<P6 EPPM database service>
target.db.type=P6
Target Database User Properties
target.db.syncuser=<P6 EPPM database sync user>
target.db.schema=<P6 EPPM database administrative user>
target.db.sysuser=<P6 EPPM database SYSDBA user>
Note: The database sync user is automatically created upon running the syncsetup script.
Server Properties
server.base_url=http://<HOST>:<PORT>/p6sync/sync
server.connectuser=<USER>
Notes:
- Contact your cloud administrator to request appropriate values for the server.base_url and server.connectuser properties.
- Leave password properties fields, such as source.db.syncuserpwd blank. The values of these properties are set when you run the syncsetup script.
- From the command line, navigate to the /prime-sync folder and run the syncsetup script:
On Windows, run:
syncsetup.cmd client_send.properties
On UNIX, run:
./syncsetup.sh client_send.properties
- When prompted, enter the password for the database sync manager, database administrative manager, database SYS user, web user, and syncadmin.
- From the command line, run the startserver script to initialize synchronization:
On Windows, run:
startserver.cmd
On UNIX, run:
./startserver.sh
- Once the server has started, run the startserver script to load the configuration:
On Windows, run:
commander.cmd LOAD client_send.properties
On UNIX, run:
./commander.sh LOAD client_send.properties
Synchronization Properties
Property | Description | Value | Example Value |
|---|---|---|---|
sync.mode | The application's role in the configured synchronization. The application sending data acts as a client, the other application acts as a server. | CLIENT | CLIENT |
sync.type | Specifies whether the application is sending or receiving synchronization requests. The client application typically sends requests, the server application typically receives requests. | RECEIVER | RECEIVER |
sync.name | The name used to identify the sync process. | Sync Name | receive1 |
sync.number | The unique synchronization number to connect to the hosted server application. Contact your cloud administrator to request the appropriate value for this property. | Sync Number | 1 |
target.db.host | The host name of the database that acts as the target of data in the synchronization. Data from the synchronization source database is shared to the target database. | Database Host Name | localhost |
target.db.port | The port number of the database that acts as the target of data in the synchronization. Data from the synchronization source database is shared to the target database. | Database Port Number | 1521 |
target.db.service | The service name of the database that acts as the target of data in the synchronization. Data from the synchronization source database is shared to the target database. | Database Service Name | pmdb |
target.db.type | The name of the application related to the target database. For example, P6 or PRIME. | Application Name | P6 |
target.db.syncuser | The name of the synchronization user of the specified target database. This user is created upon running the syncsetup script. | Database Synchronization User | syncmgr |
target.db.schema | The name of the administrative user of the target database. The default administrative user for P6 EPPM installations is admuser. | Database Administrative User | admuser |
target.db.sysuser | The name of the SYSDBA user of the target database. The default SYSDBA user on an Oracle database is SYS. | Database System User | SYS |
target.db.userts | The tablespace in the source database in which user data is stored. The default value for P6 EPPM installations is PMDB_DAT1 | Database User Tablespace Name | PMDB_DAT1 |
target.db.tempts | The tablespace in the source database in which temporary data is stored. The default value for P6 EPPM installations is TEMP. | Database Temporary Tablespace Name | TEMP |
server.base_url | The URL used to establish connection to the target server application for synchronization. Specified host and port values vary depending on your setup. Contact your cloud administrator to request the appropriate value for this property. | Server Application URL | http://localhost:4000/p6sync/sync |
server.connectuser | The user name of the user used to connect to the hosted server application. Contact your cloud administrator to request the appropriate value for this property. | Server Connection User Name | WebLogic |
optin.project_mode | The method the applications uses to determine what project data will be synchronized. For P6 EPPM-Oracle Primavera Cloud synchronizations this value should only be PRIME. | PRIME | PRIME |
optin.project_value | Specifies whether the application is using optin.project_mode. | Y | Y |