1. Purge Old Files
  2. Install and Configure the Recipe

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 Use a recipe/accelerator section, click View all.
  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 Configure icon 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 Oracle 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 22
    SFTP Connection Select Yes from the list.
  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 FTP server.
    Password Enter the password to connect to your FTP 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 Lookup Table

Edit the ORCL-OIC_SFTP_PURGE_FILES lookup table and enter appropriate values for the look up keys.

  1. In the Lookups section, click the lookup name.
  2. In the lookup table, specify values for the following keys.
    Key Description
    IntegrationID

    The key to fetch all the remaining values from the lookup.

    For example: ORCL-OIC_SFTP_PURGE_FILES
    FromEmailAddress Specifies the email address to which the error notifications are sent. Enter an email address of your choice.
    ToEmailAddress Specifies the email address from which the error notifications are sent. Enter an email address of your choice.
    EmailSubject Specifies the subject of the email error notification.
    OICSFTPPath

    The FTP directory path of the location from which to purge files.

    For example: /home/users/In
    FilePrefix The prefix of the files that are to be purged. For example: *.*
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.