You can send project data from local installations of P6 EPPM to cloud based installations of Oracle Prime using P6 EPPM-Oracle Prime synchronization. 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 setup your P6 EPPM database for synchronization with Oracle Prime:
Sync Properties
sync.mode=CLIENT
sync.type=SENDER
Source Database Properties
source.db.host=<P6 EPPM database host address>
source.db.port=<P6 EPPM database port number>
source.db.service=<P6 EPPM database service name>
Source Credential Properties
source.db.syncuser=<P6 EPPM database sync user>
source.db.schema=<P6 EPPM database administrative user>
source.db.sysuser=<P6 EPPM database SYSDBA user>
Note: The database sync user is automatically created upon running the syncsetup script.
Source Tablespace Properties
source.db.userts=<P6 EPPM user tablespace>
source.db.tempts=<P6 EPPM temp tablespace>
Server Properties
server.base_url=http://<HOST>:<PORT>/p6sync/sync
server.connectuser=<USER>
Note: Contact your cloud administrator to request appropriate values for the server.base_url and server.connectuser properties.
File Properties
file.size=100M
file.send.timeout=15
optin.project_mode=PRIME
Note: Leave password properties fields, such as source.db.syncuserpwd blank. The value of these properties are populated and encrypted when you run the syncsetup script.
Note: If you wish to sync Oracle Prime data back to P6 EPPM complete the steps in Synchronizing data from Oracle Prime to P6 EPPM before running the syncsetup script.
On Windows run ./syncsetup.cmd
On Unix based machines run ./syncsetup.sh
On Windows run ./primesync.cmd
On Unix run ./primesync.sh
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. | SENDER | SENDER |
source.db.host | The host name of the database that acts as the source of data in the synchronization. Data from the application's source database is shared to the target database of the other application. | Database Host Name | localhost |
source.db.port | The port number of the database that acts as the source of data in the synchronization. Data from the application's source database is shared to the target database of the other application. | Database Port Number | 1521 |
source. db.service | The service name of the database that acts as the source of data in the synchronization. Data from the application's source database is shared to the target database of the other application. | Database Service Name | pmdb |
source.db.type | The name of the application related to the source database. For example, P6 or PRIME. | Application Name | P6 |
source.db.syncuser | The name of the synchronization user of the specified source database. This user is created upon running the syncsetup script. | Database Synchronization User Name | syncmgr |
source.db.schema | The name of the administrative user of the source database. The default administrative user for P6 EPPM installations is admuser. | Database Administrative User Name | admuser |
source.db.sysuser | The name of the system user of the source database. The default SYSDBA user on an Oracle database is SYS. | Database SYSDBA User Name | SYS |
source.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 |
source.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 |
file.size | The maximum file size in bytes which can be sent across the synchronization. | File Size | 100M |
file.send.timeout | The amount of time in seconds after which attempts at sending data across the synchronization will timeout. | Time in Seconds | 15 |
optin.project_mode | The method the applications uses to determine what project data will be synchronized. For P6 EPPM-Oracle Prime synchronizations this value should only be PRIME. | PRIME | PRIME |
Setting Up P6 EPPM-Oracle Prime Synchronization
Synchronizing data from Oracle Prime to P6 EPPM
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, September 30, 2016