1. Sync Project Details from Oracle Primavera Cloud to PostgreSQL Using Amazon SQS
  2. About This Recipe

1 About This Recipe

Use this recipe to synchronize project details from Oracle Primavera Cloud to PostgreSQL using Amazon Simple Queue Service (Amazon SQS).

Note:

This recipe is available as Oracle Primavera Cloud — PostgreSQL | Sync Project Details in Oracle Integration. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This is a scheduled orchestration recipe that includes two integrations to synchronize project details from Oracle Primavera Cloud to PostgreSQL using Amazon SQS.

To use the recipe, you must install the recipe and configure the connection and other resources within it. When triggered, the first integration flow of the recipe - Oracle Primavera AWS SQS ProjectSync extracts the project details from Oracle Primavera Cloud and subsequently publishes the details to Amazon SQS. This in turn triggers the second integration flow of the recipe - AWS SQS PostgreSQL DB ProjectSync which consumes the published project details from Amazon SQS as messages and updates the same to the PostgreSQL database.

System and Access Requirements

  • Oracle Integration, Version 24.04 or higher

  • Oracle Primavera Cloud

  • An account on Oracle Primavera Cloud with the Administrator role

  • An IAM user account on Amazon Web Services (AWS) with AmazonSQSFullAccess permission

  • A PostgreSQL database

  • An account on the PostgreSQL database with the Administrator role