3 Install and Configure the Recipe

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

  1. On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
  2. Click Search All.
    The list of available recipes is displayed.
  3. Find and select the recipe package that you want to install, then click Install Install icon..
    A message confirms that the recipe was successfully installed, and the recipe card shows INSTALLED.
  4. After the package is installed, click Configure Configure icon on the recipe card.

    The Configuration Editor opens, displaying all the resources of the recipe package. Configure the following resources before you activate and run the recipe.

Configure the Oracle Shopify Connection

  1. In the Configuration Editor, select the connection, then click Edit Edit icon.
  2. In the Connection Properties section, enter the following details:
    Field Information to Enter
    Host Name Enter the Shopify host name. The Shopify host name appears in the Shopify home URL. For example: https://hostname.myshopify.com.
    Shopify REST API Version Enter the REST API version.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Shopify Security Policy selected.
    Username Enter the API key obtained earlier. See Configure Shopify.
    Password Enter the password obtained earlier.
    Shared secret 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 Configuration Editor, click Back Back icon . Click Save again if prompted.

Configure the Oracle ERP Cloud Connection

  1. In the Configuration Editor, select the connection, then click Edit Edit icon.
  2. In the Connection 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 Configuration Editor, click Back Back icon . Click Save again if prompted.

Update Integration Property

Update the integration property with appropriate value.

The recipe’s integration flow contains the following property:
  • EmailTo: This integration property holds the email address to which error notifications are sent. Enter an email address of your choice.
For the procedure to update the integration property, see Steps 7 to 9 in Override Design-Time Properties in an Integration.

Note:

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

Configure the Lookup Table

Edit the following lookup tables to map the fields between Shopify and Oracle ERP Cloud.

  • ORACLE-BRT-SHOPIFY_ERP_PO_LOOKUP: Used to map the fields related to the purchase order between Shopify and Oracle ERP Cloud.

  • ORACLE-BRT-SHOPIFY_ERP_PO_LINES_LOOKUP: Used to map the fields related to each line item in the purchase order between Shopify and Oracle ERP Cloud.

  • ORACLE-BRT-SHOPIFY_ERP_CURRENCY_LOOKUP: Used to map the currency fields between Shopify and Oracle ERP Cloud.

  1. In the Configuration Editor, select the lookup table, then click Edit Edit icon.
  2. In the Property column, enter the name of the Oracle ERP Cloud field you want to map.
  3. In the Value column, enter the name of the field in Shopify to which the Oracle ERP Cloud field has to be mapped.
  4. Click Save. If prompted, click Save again.
  5. To return to the Configuration Editor, click Back Back icon . Click Save again if prompted.