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 Shopify 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 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 project workspace, click Go back Back icon.

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.

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 Lookups section, click the lookup name.
  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 project workspace, click Go back Back icon.