Synchronizing data from Oracle Prime to P6 EPPM

You can send project data from cloud installations of Oracle Prime to local installations of P6 EPPM 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 synchronize data from Oracle Prime to P6 EPPM:

  1. Navigate to the folder in which P6 EPPM is installed, then navigate to the /primesync/template/ folder.
  2. Copy the rest_from_prime_client.properties file into the /primesync folder.
  3. Rename the rest_from_prime_client.properties file to rest_prime_to_p6.properties.
  4. Open rest_prime_to_p6.properties in a text editor of your choice and modify the following properties:

    Sync Properties

    sync.mode=CLIENT

    sync.type=RECEIVER

    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.

    Target Database Tablespace Properties

    target.db.userts=<P6 EPPM user tablespace>

    target.db.tempts=<P6 EPPM temp tablespace>

    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.

  5. From the command line, navigate to the /primesync folder and run the syncsetup script:

    On Windows run ./syncsetup.cmd

    On Unix based machines run ./syncsetup.sh

  6. When prompted, enter the password for the database sync manager, database administrative manager, and database SYS user.
  7. From the command line, run the primesync script to initialize synchronization:

    On Windows run ./primesync.cmd

    On Unix run ./primesync.sh

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

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

Related Topics

Setting Up P6 EPPM-Oracle Prime Synchronization

Synchronizing data from P6 EPPM to Oracle Prime



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, September 30, 2016