Preparing to Transfer Data between Applications: Example

This example demonstrates how to add deployment connections and create a business flow so data can be synchronized between applications. For the purposes of this example, let's assume that you want to transfer project content from a P6 application deployment called P6 Deployment to an Oracle Primavera Prime application deployment called Prime Deployment. Let's also assume that you want to create a business flow called Export Project Data from P6 to Oracle Primavera Prime that exports project data from the P6 EPPM database into the Oracle Primavera Prime database.

Notes:

Prerequisites

This example assumes that the following prerequisites have been completed:

Add a P6 Deployment Connection

  1. After you log into Primavera Gateway, select Configuration.
  2. Select Add.
  3. In the Add Deployment wizard:
    1. Select P6 in the Select Application Provider list.
    2. Enter P6 Deployment in the Deployment Name field.
    3. Enter A P6 deployment for synchronizing project data. in the Description field.
    4. Select Next.
    5. Enter the following deployment parameter values:
      • User Name: admin
      • Password: admin1

        Enter the P6 EPPM user name and password for a user that has administrative privileges on the P6 EPPM deployment to which you are connecting. The P6 Adapter uses this login information to connect Primavera Gateway to the P6 EPPM database.

      • Endpoint: http://myhost.us.example.com:7020/p6adapter/services/SyncServiceV1

        Primavera Gateway will use the endpoint URL to connect to the P6 deployment. The endpoint needs to point to a P6 Adapter deployment. The endpoint URL should be structured like the following: <protocol>://<domain name>:<port number>/p6adapter/services/SyncServiceV1.

      • Enable Encryption: clear this option

        If the Enable Encryption option is not selected, leave the Keystore File, Keystore Password, and Certificate Alias fields blank. Encryption should also be turned off in the P6 Admin Config utility. If the Enable Encryption option is selected, then the values in the Keystore File, Keystore Password, and Certificate Alias fields must not conflict with the values set in the Message Protection node in the P6 Administrator application.

      • P6 Currency: USD

        The P6 Currency field shows the base currency for P6 Deployment.

    6. Select Test Connection to test the endpoint URL. Fix the URL if the connection test fails.
    7. Select Save.

Add an Oracle Primavera Prime Deployment Connection

  1. Select Add.
  2. In the Add Deployment wizard:
    1. Select Prime in the Select Application Provider list.
    2. Enter Prime Deployment in the Deployment Name field.
    3. Enter A Prime deployment for synchronizing project data. in the Description field.
    4. Select Next.
    5. Enter the following deployment parameters values:
      • User Name: user
      • Password: user1

        The items in this dialog box will vary depending on the implementation details of Oracle Primavera Prime.

      • Endpoint: http://localhost:7001/primavera
    6. Select Test Connection to ensure Primavera Gateway can connect to the Prime provider.
    7. Select Save when finished.

Define a Business Flow

  1. Select Flow Type and choose Export Project Data.
  2. Select Business Flows.
  3. Select Add.
  4. In the Add Business Flow wizard:
    1. Select P6 from the Source list.
    2. Select Prime from the Destination list.
    3. (Optional) Select Compare Flag if enabled, to compare source and destination data.
    4. Note:
    5. Enter Export Project Data from P6 to Oracle Primavera Prime in the Business Flow Name field.
    6. Enter A business flow to export project data from P6 Deployment into Prime Deployment. in the Description field.
    7. Select Next.
    8. In the Gateway Object Name column, select Project.
    9. In the Field Mapping Name column, select Create Projects from P6 to Prime.
    10. In the Applied For column, select Both.
    11. Select Next.
    12. Enter the following information for the source application parameters:
      • P6 Filter: Project, Project Ids, Comma Separated IDs
        Attribute: Read only
      • Spread Period type: Week
        Attribute: Hidden
      • Synchronize WBS Hierarchy: Complete
        Attribute: Optional
    13. Select Next.
    14. Enter the following information for the destination application parameters:
      • Workspace Location: Imported Projects
        Attribute: Required
    15. Select Save.

Related Topics

Setting up Primavera Gateway

Frequent Tasks in Primavera Gateway

Viewing Business Object Fields

Viewing Field Mappings

Viewing Available Business Objects



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, March 27, 2015