Create a Connection

The first step in creating an integration is to create the connections to the applications with which you want to share data.

  1. Click Create.


    You can also create a connection in the integration canvas of:

    The Create Connection — Select Adapter dialog is displayed.

  2. Select an adapter from the dialog. You can also search for the type of adapter to use by entering a partial or full name in the Search field, and clicking Search.

    The Create New Connection dialog is displayed.

  3. Enter the information to describe the connection.

    • Enter a meaningful name to help others find your connection when they begin to create their own integrations. The name you enter is automatically added in capital letters to the Identifier field. If you modify the identifier name, do not include a blank space (for example, Sales Opportunity).

    • Select the role (direction) in which to use this connection (trigger, invoke, or both). Only the roles supported by this adapter are displayed for selection. When you select a role, only the connection properties and security policies appropriate to that role are displayed on the Connections page. If you select an adapter that supports both invoke and trigger, but select only one of those roles, then try to drag the adapter into the section you did not select, you receive an error (for example, configure an Oracle Service Cloud (RightNow) Adapter as only an invoke, but drag the adapter to the trigger section).

    • Enter an optional description of the connection.

    Description of create_new_connection.png follows
    Description of the illustration create_new_connection.png
  4. Click Create.

    Your connection is created and you are now ready to configure connection details, such as email contact, connection properties, security policies, connection login credentials, and (for certain connections) agent group.

Add a Contact Email

You can add an optional contact email address for notifications.

  1. In the Email Address field, enter an optional email address. You do not receive automatic notifications at this address.
  2. In the upper right corner, click Save.

Configure Connection Properties

Enter connection information so your application can process requests.

  1. Click Configure Connectivity.
    The Connection Properties dialog is displayed. Specify the following Oracle Database Cloud Service instance details that you obtained in Prerequisites for Creating a Connection.

  2. In the Host field, specify the host.
  3. In the Port field, specify the SQL*Net port.
  4. In the SID field, specify the database SID.
  5. In the Service Name field, specify the database service name.


    You must specify either a SID or service name value. Do not specify values for both fields.
  6. Click OK.
  7. Configure connection security.

Configure Connection Security

Configure security for your Oracle Database Cloud Service Adapter connection by selecting the security policy.

  1. Click Configure Credentials.
  2. Select the security policy.
  3. If you select Username Password Token:
    1. Enter the database username and password to connect to Oracle Database Cloud Service.
    2. Reenter the password a second time.
  4. If you select Oracle Wallet:


    The Oracle Database Cloud Service Adapter cannot be used as a trigger connection if configured with Oracle Wallet. However, all operations that you select on the Basic Info page such as Run a SQL Statement, Invoke a Stored Procedure, and Perform an Operation On a table are supported when configuring the adapter as an invoke connection.
    1. In the Wallet field, select the check box, then click Upload to upload the wallet file.
    2. Enter the wallet password, then re-enter it a second time to confirm.
    3. Enter the database username and password to connect to Oracle Database Cloud Service.
    4. Enter the database password a second time to confirm.
  5. Click OK.

Configure an Agent Group

Configure an agent group for accessing the service hosted on your premises behind the fire wall.

  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 Download and Run the On-Premises Agent Installer and About Agents and Integrations Between On-Premises Applications and Oracle Integration in Using Integrations in Oracle Integration.

Test the Connection

Test your connection to ensure that it is successfully configured.

  1. In the upper right corner of the page, click Test.
  2. If your adapter connection uses a WSDL, you are prompted to select the type of connection testing to perform:
    • Validate and Test: Performs a full validation of the WSDL, including processing of the imported schemas and WSDLs. Complete validation can take several minutes depending on the number of imported schemas and WSDLs. No requests are sent to the operations exposed in the WSDL.

    • Test: Connects to the WSDL URL and performs a syntax check on the WSDL. No requests are sent to the operations exposed in the WSDL.

    If successful, the following message is displayed and the progress indicator shows 100%.

    Connection connection_name was tested successfully.

  3. If your connection was unsuccessful, an error message is displayed with details. Verify that the configuration details you entered are correct.
  4. When complete, click Save, then click Close.