1. Sync Project Details from Oracle Primavera Cloud to PostgreSQL Using Amazon SQS
  2. Before You Install the Recipe

2 Before You Install the Recipe

You must perform the following configuration tasks on your Amazon SQS, Oracle Primavera Cloud and PostgreSQL instances to successfully connect to these external systems using Oracle Integration and sync project details.

Configure Amazon SQS

To access Amazon SQS using Oracle Integration, you must perform the following configuration tasks.

  1. Create an AWS Account
  2. Create an IAM User and Obtain the Access Key and Secret Access Key
In addition, review the connection properties and securities that you have to configure in Create a Connection.

Configure Oracle Primavera Cloud

To access Oracle Primavera Cloud from Oracle Integration, you must have a separate user account on Oracle Primavera Cloud.

Log in to your Oracle Primavera Cloud instance as an Administrator and perform the following tasks.
  1. Create a user account for Oracle Integration. Make a note of the username and password set for the account. You must use the credentials of this user account to connect to Oracle Primavera Cloud from Oracle Integration.
  2. The user account must have Read permission for the project object.

Configure PostgreSQL

To access the PostgreSQL database from Oracle Integration and sync project details, you must perform certain configurations on your PostgreSQL instance.

For general configuration tasks, see Prerequisites for Creating a Connection.

In addition, you have to create a database table. To create a database table:

  1. Log in to your PostgreSQL Workbench instance as an Administrator.
  2. On the left navigation pane, expand Schemas and then public.
  3. Create the database table in either of the two ways given below.
    1. Right-click on the public schema.
    2. Click Query Tool.
    3. Paste the query on the Query tool and then execute.

    or,

    1. Under public schema, right-click Tables, select Create and then Tables.
    2. In the Create-Table dialog, specify the name of the table as primavera_projects_tab.
    3. Right-click on the empty table, and under Create select Column.

      Download primavera_projects_tab.sql for sample data to populate in the columns of the database table.

    4. Click Save.