Install and Configure the Recipe

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

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the FTP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    FTP Server Host Address Enter the host address of your sFTP server.
    FTP Server Port Enter FTP server Port number.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    Username Enter the username to connect to your sFTP server.
    Password Enter the password to connect to your sFTP server.
  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 Back icon.

Configure the Amazon S3 Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    AWS Region Select the AWS region where you have created the Amazon S3 bucket. See Configure Amazon S3.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select AWS Signature Version 4 and RSA Signature Validation Policy.
    Access Key Enter the access key that you obtained. Configure Amazon S3.
    Secret Key Enter the secret key that you obtained. Configure Amazon S3.
    AWS Region Select the AWS region where you have created the Amazon S3 bucket. For example, ap-south-1.
    Service Name Select Amazon Simple Storage Service (Amazon S3).
  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 Back icon.

Configure Amazon SNS Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    AWS Region Select the AWS region where you have created the Amazon S3 bucket. See Configure Amazon S3.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select AWS Signature Version 4 and RSA Signature Validation Policy.
    Access Key Enter the access key that you obtained. Configure Amazon S3.
    Secret Key Enter the secret key that you obtained. Configure Amazon S3.
    AWS Region Select the AWS region where you have created the Amazon S3 bucket. For example, ap-south-1.
    Client Identifier Enter the Client Identifier. See Configure Amazon SNS.
  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 Back icon.

Configure Oracle ERP Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    Username Enter the username of the account created for Oracle Integration on the Oracle ERP Cloud instance. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on the Oracle ERP Cloud instance. See Configure Oracle ERP Cloud.
  3. Click Save. If prompted, click Save again.
  4. 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.

  5. To return to the project workspace, click Go back Back icon.

Update Integration Properties

Update the following integration properties with appropriate values.

  1. In the Integrations section, click Actions Actions icon on the AMAZON SNS S3 ERP FileUpload integration flow, then select Update property values.
  2. In the Update property values panel, update the integration properties with appropriate values.
    1. retryWait: Wait time before retrying a failed operation.
    2. EmailTo: Email address to which runtime exception emails are sent. Enter an email address of your choice.
    3. RetryCount: Number of retries to attempt if a record fails while importing employee records at run time. Enter a number of your choice.
  3. Click Submit.

    Note:

    This is an app-driven integration, and you can update the property values only before activating the recipe.

    A message confirms that the integration properties have been updated successfully.