3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

1. On the Oracle Integration Home page, in the Get started section, click Browse store.
2. Find the recipe you want to install, then click Get.

   A message confirms that the recipe was successfully installed, and the recipe card shows In use.

3. Click Configure on the recipe to configure its resources.

   The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Amazon SQS Connection

1. In the Connections section, click the connection name.
2. In the Properties section, enter the AWS region name. For example: ap-south-1.
3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Amazon Signature Version 4.
   Access Key	Enter the access key obtained from the AWS instance. See Configure Amazon SQS.
   Secret Key	Enter the secret key obtained from the AWS instance.
   AWS Region	Select the same AWS region that you entered in step 2 (ap-south-1).

4. Click Save. If prompted, click Save again.
5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

   A message confirms if your test is successful.

6. To return to the project workspace, click Go back .

Configure the Oracle Primavera Cloud Connection

1. In the Connections section, click the connection name.
2. In the Properties section, enter the Oracle Primavera Cloud host name. For example: https://your_domain_name.oraclecloud.com.
3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Oracle Primavera Cloud Login.
   Username	Enter the username of the account created for Oracle Integration on the Oracle Primavera Cloud instance. See Configure Oracle Primavera Cloud.
   Password	Enter the password of the account created for Oracle Integration on the Oracle Primavera Cloud instance.

4. Click Save. If prompted, click Save again.
5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

   A message confirms if your test is successful.

6. To return to the project workspace, click Go back .

Configure the PostgreSQL Connection

1. In the Connections section, click the connection name.
2. In the Properties section, enter the following details:

   Field	Information to Enter
   Host Name	Enter the PostgreSQL host name. See Configure PostgreSQL.
   Port	Enter the PostgreSQL port.
   Database Name	Enter the name of the database.

3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Username Password Token.
   Username	Enter the username of your PostgreSQL instance.
   Password	Enter the password of your PostgreSQL instance.

4. Click Save. If prompted, click Save again.
5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

   A message confirms if your test is successful.

6. To return to the project workspace, click Go back .

Configure the Lookup Table

Edit the ORACLE-BRT-AWS_SQS_PROPERTY lookup table and enter appropriate values.

1. In the Lookups section, click the lookup name.
2. In the Property_Name column, enter the name of the column.
3. In the Property_Value column, enter the value as shown in the table below.

   Property	Description	Value
   QueueURL	Specifies the Queue URL.	https://sqs.<AWS Region>.amazonaws.com/<AWS Account ID>/<Queue Name>.fifo

4. Click Save. If prompted, click Save again.
5. To return to the project workspace, click Go back .