Configuring Connections in Oracle Integration Cloud

After the packages are imported and verified, the respective connections have to be configured.

This section describes the procedure to set up the connections.

• Configuring Oracle Utilities REST CCB for Notif Hub Connection

• Configuring Oracle Utilities OCI Streaming for Notif Hub Connection

• Configuring Oracle Utilities Notif DB Connection

• Configuring Oracle Utilities REST Responsys for Notif Hub Connection

• Configuring Oracle Utilities SFTP for Notif Hub Connection

• Configuring Oracle Utilities REST for Notif Hub Connection

Configuring Oracle Utilities REST CCB for Notif Hub Connection

This connection is used to communicate with Oracle Utilities Customer Cloud Service using the Oracle Utilities Adapter.

To configure the Oracle Utilities REST CCB for Notif Hub connection:

1. Add the Oracle Utilities Customer Care and Billing REST web catalog to the catalogURL section.

The REST Catalog URL follows this format:

https://{host}:{port}/{tenant}/{domain}/{appName}/rest/openapi/iws/catalog

2. From the Security Policy drop-down list, select the Basic Authentication policy.

3. Provide Username and Password to connect to Oracle Utilities Customer Cloud Service.

4. Click Test on the upper-right corner.

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

Configuring Oracle Utilities OCI Streaming for Notif Hub Connection

This connection is used to communicate with Oracle Cloud Infrastructure (OCI) Streams using the OCI Streaming adapter.

To configure Oracle Utilities OCI Streaming for Notif Hub connection:

1. Add the Bootstrap Server.

Know the host and port of the bootstrap server to use to connect to a list of Oracle Cloud Infrastructure Streaming Services.

2. From the Security Policy drop-down list, select the SASL PLAIN Over SSL OSS policy.

3. Provide the SASL Username and Password.

4. Provide the TrustStore.

5. Provide the Agent Group.

6. Click Test on the upper-right corner.

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

Refer to https://docs.oracle.com/en/cloud/paas/integration-cloud/stream-service-adapter/create-streaming-service-adapter-connection.html for more information.

Configuring Oracle Utilities Notif DB Connection

This connection is used to communicate with the Oracle Utilities Network Management System database using the Oracle DB adapter.

To configure Oracle Utilities Notification Hub DB connection:

1. Add the Database Host, Port and Service Name.

Know the host and port for the Oracle Utilities Network Management System database to connect to.

2. From the Security Policy drop-down list, select the Username Password Token policy.

3. Provide the Username and Password.

4. Provide the Agent Group.

5. Click Test at the upper-right corner.

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

Configuring Oracle Utilities REST Responsys for Notif Hub Connection

This connection is used to communicate with Oracle Responsys using the REST adapter.

To configure the Oracle Utilities REST Responsys for Notif Hub connection:

1. Select Connection Type REST API Base URL.

2. Add the Connection URL.

3. From the Security Policy drop-down list, select the OAuth Custom Two Legged Flow policy.

4. Provide Access Token Request.

5. A sample Access Token Request is as below:

-X POST https://host/rest/api/v1.3/auth/token -H "Content-Type: application/x-www-form-urlencoded" -d "user_name=oic_api@oracleuti&password=1234&auth_type=password"

6. The user_name and password should be a API user and password.

7. Specify $access_token as authToken.

8. Specify access_token_usage as -H Authorization: ${access_token}.

9. Click Test at the upper-right corner.

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

Note: The Oracle Utilities OCI Stream Responsys Notif Send integration process invokes three Oracle Responsys instances out of the box. Hence, this Oracle Integration Cloud process requires three Oracle Responsys connections to be configured. Oracle Utilities REST Responsys2 for Notif Hub Connection and Oracle Utilities REST Responsyse3 for Notif Hub Connections can be configured to different Oracle Responsys instances following the same connection configurations.

The Oracle Integration Cloud process validates all the configured connections during activation. If fewer than three different Oracle Responsys instances are used, then same connection configurations should be duplicated in the unused connection to have valid connections in the flow.

Configuring Oracle Utilities SFTP for Notif Hub Connection

This connection is used to communicate with the SFTP Server that Oracle Responsys is connecting to using the Oracle FTP adapter.

To configure Oracle Utilities SFTP for Notif Hub connection:

1. Add the FTP Server Host Address and FTP Server Port.

2. Know the host and port of the FTP Server to use to connect to get Oracle Responsys related files.

3. From the Security Policy drop-down list, select the SASL PLAIN Over SSL OSS policy.

4. Provide the SASL Username and Password.

5. Provide the TrustStore and Agent Group.

6. Click Test on the upper-right corner.

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

Refer to https://docs.oracle.com/en/cloud/paas/integration-cloud/stream-service- adapter/create-streaming-service-adapter-connection.html for more information.

Configuring Oracle Utilities REST for Notif Hub Connection

This connection is used in Oracle Utilities Responsys CCB Cust Contact Create process. It is a trigger connection used to receive requests from Oracle Utilities Responsys CED process.

To configure the Oracle Utilities REST for Notif Hub connection:

1. Select Security to be the Basic authentication.

2. Click Test on the upper-right corner.

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