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 REST OIC API Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Connection Type Leave REST API Base URL selected.
    Connection URL Enter the host name of the Oracle Integration instance where you installed the recipe.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Basic Authentication.
    User Name Enter the user name of the Oracle Integration user account with the Service Invoker role. See System and Access Requirements.
    Password Enter the password of the Oracle Integration user account with the Service Invoker role.
  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 MICROS Reporting and Analytics BI API Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Connection Type Leave REST API Base URL selected.
    Connection URL

    Enter the domain used to log into the Reporting and Analytics instance.

    For more information, see Send Requests in the Business Intelligence API Guide.

  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select OAuth Custom Three Legged Flow.
    Authorization Request

    Enter the authorization request format.

    Example: https://BIAPI_IDM_Server_HOST/oidc-provider/v1/oauth2/authorize?response_type=code&client_id= client_id &scope=openid&redirect_uri=https://OIC_HOST/icsapis/agent/oauth/callback&code_challenge=code_challenge&code_challenge_method=S256

    Access Token Request

    Enter the access token request format.

    Example: -X POST -H 'Content-Type: application/x-www-form-urlencoded' -d 'grant_type=authorization_code&code=${auth_code}&redirect_uri=https://OIC_HOST/icsapis/agent/oauth/callback&code_verifier=code_verifier&client_id=client_id' https://BIAPI_IDM_Server_HOST/oidc-provider/v1/oauth2/token

    Refresh Token Request

    Enter the refresh token request format.

    Example: -X POST -H 'Content-Type: application/x-www-form-urlencoded' -d 'grant_type=refresh_token&refresh_token=${refresh_token}&redirect_uri=https://OIC_HOST/icsapis/agent/oauth/callback&code_verifier=code_verifier&client_id=client_id' https://BIAPI_IDM_Server_HOST/oidc-provider/v1/oauth2/token

    $auth_code code
    $access_token access_token
    $refresh_token refresh_token
    $expiry expires_in
    $token_type token_type
    access_token_usage -H Authorization: ${token_type} ${access_token}
  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 ATP Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Service Name.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select JDBC Over SSL.
    Wallet Upload the wallet zip file.
    Wallet Password Enter the password for the wallet.
    Database Service Username Enter the service user name of the Database created for Oracle Integration on ATP.
    Database Service Password Enter the password of the Database created for Oracle Integration on ATP.

    Note:

    These configurations indicate a wallet-based connectivity to ATP. This may vary depending on the type of ATP and its authentication mechanism used in your instance. Configure the connection accordingly.

  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 Table

Edit the ORACLE-BRT-Micros_ErrorNotification_Config lookup table and enter the necessary values.

  1. In the Lookups section, click the lookup name.
  2. The ORACLE-BRT-Micros_ErrorNotification_Config lookup table contains the information needed to trigger the error handlers. Enter the required information for the following parameters:
    Parameter Information to Enter
    OIC The Oracle Integration Admin email address that must be notified on failures.
    ERP The Oracle Integration Admin email address that must be notified on failures.
    Micros The Oracle Integration Admin email address that must be notified on failures.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.