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 Shopify Connection

  1. In the Connections section, click the connection name.
  2. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Shopify Security Policy.
    Username Enter the username of the account created for Oracle Integration on Shopify. See Configure Shopify.
    Password Enter the password of the account created for Oracle Integration on Shopify.
  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.

Configure the OData Connection for S/4HANA

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    OData Service Root URL Enter the OData Service Root URL. For example: https://<host>/sap/opu/odata/sap/<service_name>
    OData Version Enter the OData Version. Example: V2
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Basic Authentication.
    Username Enter the username of the account created for Oracle Integration on OData. See Configure OData for SAP S/4HANA.
    Password Enter the password of the account created for Oracle Integration on OData.
  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

Users can pass the value while running the integration by updating the integration property value.

  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. EmailTo: This integration property holds the email address to which error notification emails are sent. Enter an email address of your choice.
    2. retryCount: This integration property holds the number of retries when an invoke fails.
  3. Click Submit.

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

Configure the Lookup Tables

The recipe contains the following lookup tables. Edit the lookup tables as necessary.

  • ORACLE-BRT-SHOPIFY_S4HANA_SALES_ORDER_PROPERTIES: This lookup table contains Sales Order properties for S/4HANA.

    Property Description Value (Example)
    SalesOrderType Classification of sales orders. OR
    SalesOrganization Specify the organizational unit responsible for sales activities. 1710
    DistributionChannel Specific distribution channel through which products are sold and distributed. 10
    OrganizationDivision Specific internal business division or category within the organization. 00
    BusinessPartnerCategory Specific category or classification of business partners. 22
    Language Select the language. EN
    BusinessPartnerIsBlocked Flag indicating blocked business partners. FALSE
    Material Products or items available for sale. FG111
    SalesOrderItemCategory Categorization of individual items within an order. TAN
  • ORACLE-BRT-SHOPIFY_METAFIELD_PROPERTIES

    Property Description Value
    namespace Specifies the category to which the property belongs. order
    key Unique identifier for the property. S4hanaOderId
    value_type Specifies the data type of the key attribute. integer
  1. In the Lookups section, click the lookup name.
  2. In the Property column, enter the name of the column.
  3. 3. In the Value column, enter the values as shown in the table below to which the property name must be mapped.
    Field Information to Enter
    Hostname Enter the Shopify host name. For example: https://oicpm.myshopify.com
    Shopify REST API Version Enter the OData Version. Example: 2023-01.
  4. Click Save. If prompted, click Save again.
  5. To return to the project workspace, click Go back Back icon.