- Integrate Oracle MICROS Reporting and Analytics with ATP
- Install and Configure the Recipe
3 Install and Configure the Recipe
On your Oracle Integration instance, install the recipe package to deploy and configure the integration and associated resources.
- On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
- Click Search
All.The list of available recipes is displayed.
- Find and select the recipe
package that you want to install, then click Install
.A message confirms that the recipe was successfully installed, and the recipe card shows In use.
- After the package is installed,
click Configure
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 REST OIC API Connection
- In the Configuration Editor, click the connection name.
- In the Connection 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. - 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. - Click Save. If prompted, click Save again.
- 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.
- To return to the Configuration Editor, click Back . Click Save again if prompted.
Configure the Oracle MICROS Reporting and Analytics BI API Connection
- In the Configuration Editor, click the connection name.
To learn more about the configuration, see Authenticate in the Business Intelligence API Guide.
- In the Connection 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.
- 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}
- Click Save. If prompted, click Save again.
- 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.
- To return to the Configuration Editor, click Back . Click Save again if prompted.
Configure the Oracle ATP Cloud Connection MICROS
- In the Configuration Editor, click the connection name.
- In the Connection Properties section, enter the Service Name.
- 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.
- Click Save. If prompted, click Save again.
- 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.
- To return to the Configuration Editor, click Back . Click Save again if prompted.
Configure the Lookup Table
Edit the ORACLE-BRT-Micros_ErrorNotification_Config lookup table and enter the necessary values.
- In the Configuration Editor, click the lookup table name.
- 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. - Click Save. If prompted, click Save again.
- To return to the Configuration Editor, click Back . Click Save again if prompted.