Establish the Connections for Oracle E-Business Suite and REST Services

In this integration example, you need to create the following two connections:

  • Connection for Oracle E-Business Suite

    Once the connection to an Oracle E-Business Suite instance is successfully established, you can add the Oracle E-Business Suite Adapter as invoke (target) connections later in an integration.

  • Connection for REST services

    You need to establish the connection for REST services. You can add this REST connection as a trigger (source) connection later in an integration.

Create an Oracle E-Businss Suite Connection with Oracle E-Business Suite Adapter

Perform the following steps to establish the connection for Oracle E-Businss Suite in Oracle Integration:

  1. In the navigation pane, click Home > Integrations > Connections.

  2. On the Connections page, click Create.

    In the Create Connection - Select Adapter dialog appears. Scroll down and select "Oracle E-Business Suite" from the dialog. You can optionally use the search feature to enter a full or partial name to locate the Oracle E-Business Suite Adapter from the dialog. Click the Select button for "Oracle E-Business Suite" to create a connection through the Oracle E-Business Suite Adapter.

  3. In the Create Connection dialog, enter the following information for your connection:

    • Connection Name: Enter "EBSDemo".

    • Identifier: Accept the default populated identifier, such as "EBSDEMO".

    • Keywords: Leave this blank.
    • Connection Role: Select the "Trigger and Invoke" role for this connection.

    • Description: Enter "Use the Oracle E-Business Suite Adapter connection in an integration" as the description.

    Click Create to create the connection.

  4. Enter additional connection details by specifying the following information:

    • In the Connection Properties dialog, enter a URL (http://<Oracle E-Business Suite host name>:<port>) to connect to an Oracle E-Busiess Suite instance.

    • In the Security section, ensure that the Basic Authentication is selected as the security policy.

      Enter operations as the user name and its associated password to access the Oracle E-Business Suite instance you specified earlier in the Connection Properties section.

    • Click Configure Agents to display the Select an Agent group dialog. A list of available agent groups is automatically populated for your selection.

      Select a desired agent group, such as "EBS", and click Use to enable the selection.

    After you specify the connection information for "EBSDemo", the connection details page is displayed.

  5. Click Test to test the connection you just specified for Oracle E-Business Suite.

  6. Click Save and then click Back button.

The Oracle E-Business Suite connection "EBSDemo" now appears in the Connections page.

Create an Connection for REST Services in This Example

Perform the following steps to create an connection for REST APIs:

  1. On the Connections page, click Create.

    The Create Connection - Select Adapter dialog appears.

  2. Scroll down and select "REST" from the dialog. You can optionally use the search feature to enter a full or partial name to locate the REST Adapter from the dialog.

    Click the Select button for "REST" to create an connection through the REST Adapter.

  3. The Create Connection dialog appears.

    Enter "RESTSample" as the Connection Name. The identifier value, GENERICREST, is automatically populated. Leave the optional Keywords field blank.

    Select "Trigger" as the Connection Role. Enter a meaningful description for this connection, such as "The sample source REST endpoint".

  4. Click Create to create the connection.

  5. Enter the following information for your connection:

    • In the Connection Properties section, select "REST API Base URL" as the Connection Type and enter a connection URL (http://<Oracle E-Business Suite host name>:<port>/webservices/rest/autoinvoice/RA_INTERFACE_LINES_ALL) to connect to an instance for REST services.

    • In the Security section, enter operations as the user name and its associated password to access the instance for REST services you specified earlier in the Connection Properties section.
  6. Click Test to test the connection you just specified for REST services.

  7. Click Save and then click Back button.

The "RESTSample" connection for REST services appears in the Connections page, along with the Oracle E-Business Suite connection "EBSDemo" that you created earlier.