Oracle Integration Cloud Connections

Configuring Connections in Oracle Integration Cloud

After the project is imported and verified, configure the respective connections.

This section describes the procedure to configure the following:

OU REST OPOWER for CCS-OPOWER Connection

This connection is used to communicate with Oracle Utilities Opower GraphQL APIs using the REST adapter.

To configure this connection:

  1. In Connection Properties, select “REST API Base URL” as the Connection Type.

  2. Add the Oracle Utilities Opower GraphQL API Connection URL.

    Example: https://<hostname>/graphql

  3. In the Security section, select the applicable security policy to access the application.

    Note: See Create a REST Adapter Connection in the Oracle Utilities Adapter documentation for more information on the supported security policies.

  4. On the Connection page, click Test.

  5. After the connection is tested successfully, click Save.

OU REST CCS for CCS-OPOWER Connection

This connection is used to communicate with Oracle Utilities Customer Cloud Service application service using the Utilities adapter.

To configure this connection:

  1. Add the Oracle Utilities Customer Cloud Service catalog URL in the Catalog URL field.

    • For Customer Cloud Service (CCS) Catalog format: https://{host}:{port}/{tenant}/{domain}/{appName}/rest/openapi/iws/catalog

      Example: https://ccsHost:port/tenantName/test/ccs/rest/openapi/iws/catalog

    • For Customer Care and Billing (CCB) On Premise Catalog format:

      https://{host}:{port}/{context}/rest/ouaf/openapi/iws/catalog

      Example: https://ccbHost:port/ouaf/rest/ouaf/openapi/iws/catalog

  2. In the Security section, select the applicable security policy to access the application.

    Note: See Create Oracle Utilities Adapter Connection in the Oracle Utilities Adapter documentation for more information on the supported security policies.

  3. If connecting to the Oracle Utilities Customer Care and Billing on-premise application, configure the agent:

    1. In the Agent Group section, click Configure Agents.
    2. Select the agent group from the list created in Creating an Agent Group.
  4. On the Connection page, enter the username and click Test at the upper-right corner to test the connection.

  5. After the connection is tested successfully, click Save.

OU REST TRIG for CCS-OPOWER Connection

This connection is used to expose the integration as a REST service. To configure this connection:

  1. Select “OAuth 2.0” or “Basic Auth” as the Security policy and select “Trigger” as the Role.
  2. On the Connection page, click Test.
  3. Once the connection has been tested successfully, click Save.

OU REST INVK OIC for CCS-OPOWER Connection

This connection is used to invoke Oracle Integration Cloud APIs and local integrations that accept a multipart request for passing attachment reference using the REST adapter.

To configure this connection:

  1. In Connection Properties, select “REST API Base URL” as the Connection Type.

  2. Add the Oracle Integration Cloud Connection URL.

    Example: https://OIC_CloundInstance.com

  3. In the Security section, select the applicable security policy to access the application.

    Note: See Create Oracle Utilities Adapter Connection in the Oracle Utilities Adapter documentation for more information on the supported security policies.

  4. On the Connection page, click Test.

  5. After the connection is tested successfully, click Save.

OU REST OPOWER Object Storage for CCS-OPOWER Connection

This connection is used to communicate with Oracle Cloud Infrastructure Object Storage Service APIs using the REST adapter.

Note: This is for Oracle Utilities Opower Object Storage.

To configure this connection:

  1. In Connection Properties, enter the Object Storage API endpoint in the Connection URL.

    Connection Type: REST API Base URL

    Connection URL format: https://objectstorage.{region}.oraclecloud.com

    Note: To see the Object Storage Service API and endpoints, refer to the Oracle Cloud Infrastructure documentation/API Reference and Endpoints.

  2. In the Security section:

    2.a If selecting OCI Service Invocation security policy

    2.b If selecting the OCI Signature Version 1 security policy.

    • Provide the following Object Storage information:
      • Tenancy OCID
      • User OCID
      • Upload the private key
      • Fingerprint (obtained from object storage after register the public key for the appropriate user)

    Note: For more information, refer to the Object Storage Setup Guide 20C.

  3. After the connection is tested successfully, click Save.

OU REST CCS Object Storage for CCS-OPOWER Connection

This connection is used to communicate with Oracle Cloud Infrastructure Object Storage Service APIs using the REST adapter.

Note: This is for Oracle Utilities Customer Cloud Service Object Storage.

To configure this connection:

  1. In Connection Properties, enter the Object Storage API endpoint in the Connection URL.

    Connection Type: REST API Base URL

    Connection URL format: https://objectstorage.{region}.oraclecloud.com

    Note: To see the Object Storage Service API and endpoints, refer to the Oracle Cloud Infrastructure documentation/API Reference and Endpoints.

  2. In the Security section:

    2a. If selecting the OCI Service Invocation security policy

    2.b If selecting OCI Signature Version 1 security policy.

    • Provide the following Object Storage information:
      • Tenancy OCID
      • User OCID
      • Upload the private key
      • Fingerprint (obtained from object storage after registering the public key for the appropriate user)

    Note: For more information, refer to the Object Storage Setup Guide 20C

  3. After the connection is tested successfully, click Save.

OU FTP CCS for CCS-OPOWER Connection

This connection is used to communicate with the Oracle Utilities Customer Cloud Service FTP Server using the FTP adapter.

To configure this connection:

  1. In the Connection Properties section, enter the FTP Server Host Address and the FTP Server Port.

  2. Expand Optional Properties. In the SFTP Connection field, select Yes.

  3. In the Security section, select the applicable security policy for the Oracle Utilities Customer Cloud Service Application FTP Server.

    Example: You can select the FTP Server Access policy on the Security Policy tab, then enter the Oracle Utilities Customer Cloud Service FTP Server username and password.

    Note: For more information on the supported security policies, see Create an FTP Adapter Connection in the Integration 3 documentation.

  4. Configure the appropriate Agent Group if applicable.

  5. On the Connection page, click Test.

  6. Once the connection has been tested successfully, click Save.

    Note: Make sure the FTP Server is set up and configured in Oracle Utilities Customer Cloud Service.