Install and Configure the Recipe

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

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the Salesforce REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Salesforce Domain URL Specify the Salesforce domain URL, see Configure Salesforce
    API Version Enter your current Salesforce API version. To obtain the API version, see Configure Salesforce.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Authorization Code Credentials.
    Client ID Enter the username of the account created for Oracle Integration on Salesforce. See Configure Salesforce.
    Client Secret Enter the password of the account created for Oracle Integration on Salesforce.

    Note:

    To the password, you must also append the security token generated for the same account.
  4. Click Save. If prompted, click Save again.
  5. Click Provide Consent.
  6. In the resulting Sign in dialog, enter your Oracle Integration user name and password, and click Sign in.
    You'll now be redirected to the Salesforce login page.
  7. Enter your Salesforce account credentials and click Continue to log in.
    You are now displayed a page that prompts you to authorize the connection to the Salesforce application created previously.
  8. On the Salesforce web page, click ACCEPT.
    You're informed that access to Salesforce is allowed. You can now switch back to the Salesforce Connection window of Oracle Integration to test your connection.
  9. 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.

  10. To return to the project workspace, click Go back Back icon.

Configure the SAP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, upload the JCO connection properties file.
    You must upload the following type of JCO file:
      • Adapter inbound properties file: To configure the SAP Adapter for both trigger and invoke connections (for example, the Adapter_inbound_Direct.properties file).
  3. In the Security section, enter the username and password to connect to the SAP instance.
  4. In the Agent Group section, configure an agent group for accessing the service hosted on your premises, behind the firewall.
    1. Click Configure Agents.
      The Select an Agent Group page appears.
    2. Click the name of the agent group.
    3. Click Use.

    To configure an agent group, you must download and install the on-premises connectivity agent. See Downloading and Running the On-Premises Agent Installer in Using Integrations in Oracle Integration 3.

  5. Click Save. If prompted, click Save again.
  6. 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.

  7. To return to the project workspace, click Go back Back icon.

Update Integration Property

Update the integration property with appropriate 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 following integration property with appropriate value.
    • Email_Id: This integration property holds the email address to which run-time exception emails are sent. Enter an email address of your choice.
  3. Click Submit.

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

Configure the Lookup Table

Edit the lookup table, and enter an email ID to receive error messages.

  1. In the Lookups section, click the lookup name.
  2. Label the first and second column as SAP_Parameter and Parameter_Value respectively.
  3. In the SAP_Parameter column, enter the parameter name as Convert.
  4. In the Parameter_Value column, enter the value X.
  5. Click Save. If prompted, click Save again.
  6. To return to the project workspace, click Go back Back icon.