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.
  3. Hover over the recipe, then click Install Install icon.

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

  4. Hover over the recipe again, and click Configure Configure icon to configure the resources of the recipe.

    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 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 Oracle ERP Cloud. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  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 Oracle Shopify REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, in the Hostname field, enter the URL of your Shopify instance. For example: https://your_domain_name.myshopify.com/
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username Enter the API key obtained earlier. See Configure Shopify.
    Password Enter the Shared Secret obtained earlier.
  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 Oracle REST Trigger Connection

  1. In the Connections section, click the connection name.
  2. Click Save. If prompted, click Save again.
  3. 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.
  4. To return to the project workspace, click Go back Back icon.

Configure the Oracle FTP Connection

Use the following steps to configure the Oracle FTP Connection connection.

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    1. FTP Server Host Address: Enter the host address of your sFTP server.
    2. FTP Server Port: Enter 22.
    3. SFTP Connection: specify the value as Yes.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    User Name Enter the user name to connect to your sFTP server.
    Private Key File 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 Oracle UCM Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the WSDL URL. For example: https://erp-hostname/idcws/GenericSoapPort?wsdl
  3. In the Security section, enter the following details:
    Field Information to Enter
    User Name Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  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 Tables

  1. In the Lookups section, click the lookup name.
  2. Enter the field names and corresponding values. Refer to the details provided for each table below.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.
The recipe contains the following two lookup tables. Edit them as necessary.
  • ORACLE-BRT-PDH_SHOPIFY_CONSTANTS: Used to map WeightUnit of items in Shopify with the corresponding WeightUnit of items in Oracle ERP Cloud.
    Weight Unit in Oracle ERP Cloud Weight Unit in Shopify
    kg KILOGRAMS
  • ORACLE-BRT-ERP_Shopify_PdSync_Notification_Const: Used to configure the email address to which the error notifications are sent when the recipe fails.
    Email_Property Email_Value
    fromAddress Specify the email address from which the notification emails are sent. Enter an email address of your choice.
    toAddress Specify the email address to which the notification emails are sent. Enter an email address of your choice.