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 Oracle ERP Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name 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.
  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 MySQL 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 MySQL server host name.
    Port Enter the MySQL port.
    Database Name Enter oic schema?sslMode=DISABLED.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Username Enter the username of your MySQL instance.
    Password Enter the password of your MySQL 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 Back icon.

Update Integration Properties

Note:

As the recipe contains an app-driven integration, you can update the integration properties only before activating the recipe.
  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. ToEmail: This integration property holds the email address to which error notifications are sent. Enter an email address of your choice.
    2. FromEmail: This integration property holds the email address from which error notifications are sent. Enter an email address of your choice.
  3. Click Submit.

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