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 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 REST EPM Connection

  1. In the Connections section, click the connection name.
  2. In the Security section, select OAuth 2.0 Or Basic Authentication as the security policy.
  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

  1. In the Integrations section, click Actions Actions icon on the integration flow, then select Update property values.
  2. In the Update property values panel, update the integration properties with appropriate values.
    1. directory: This is the folder location on the FTP server where the file is located. For example: /Data/Jan/records. See Before You Install the Recipe. This is a required property.
    2. filename: This is the file which has to be downloaded from the FTP server location. For example: dataFile.dat. This is a required property.
    3. stage_location: This is the temporary location on Oracle Integration where the file would be downloaded. For example: tmp. This property is optional.
    4. epm_folder_path: The folder in EPM cloud where the file has to be imported. For example: /inbox/Jan. This property is optional.
  3. Click Submit.

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