Configuring Connections in Oracle Integration Cloud
After the packages are imported and verified, the respective connections must be configured.
This section describes the procedure to set up the following connections:
Configuring Oracle Utilites SOAP WACS for ArcGIS-OFS Connection
This connection is used to communicate with Oracle Utilities Work and Asset Cloud Service using the Oracle Utilities adapter.
To configure the OU SOAP WACS for ArcGIS-OFS connection:
1. Add the Oracle Utilities Work and Asset applications catalog to the CatalogURL field on the Oracle Integration Cloud Connection page.
In the on-premises applications, make sure that the catalog is in the following format:
http(s)://<WAM_HOST>:<WAM_PORT>/<ContextRoot>/webservices/builtin/ServiceCatalog?wsdl
If you are using Oracle Utilities Work and Asset Cloud Service, the format should be: https://{host}:{port}/{tenant}/{domain}/{appName}/soap/api/ iws/ServiceCatalog?WSDL
2. On the Security policy tab, select the applicable security policy. Refer to the Oracle Utilities Adapter documentation for more information on the supported security policies at: https://docs.oracle.com/en/cloud/paas/application-integration/utilities-adapters/create-oracle-utilities-adapter-connection.html
3. In case of Oracle Utilities Work and Asset on-premises, configure the agent in the connection.
a. In the Agent Group section, click Configure Agents.
b. Select the agent group from the list created in Creating an Agent Group.
4. On the Connection page, enter the username and password. Click Test at the upper-right corner to test the connection.
5. After the connection is tested successfully, click Save.
Configuring Oracle Utilities OFS for ArcGIS-OFS Connection
This connection is used to communicate with Oracle Field Service using the Oracle Field Service adapter.
Configure the Oracle Utilities OFS for ArcGIS-OFS connection with the required details:
1. Enter the API URL in the Field Service Cloud API URL field.
Example: https://<ofsc instance id>.fs.ocs.oraclecloud.com
2. Enter the Instance ID.
3. From the Security Policy drop-down list, select Basic Authentication.
4. As part of the user name and password, provide the ClientID and Client Secret (you can retrieve them from the Oracle Field Service environment).
Note: For more information, refer to the Oracle Field Service documentation.
5. On the Connection page, enter the user name and password.
6. Click Test at the upper-right corner to test the connection.
7. After the connection is tested successfully, click Save.
Configuring Oracle Utilities REST OFS API for ArcGIS-OFS Connection
This connection is used to communicate with the OFSC API using the REST adapter.
Configure the Oracle Utilities REST OFS for ArcGIS-OFS connection with required details:
1. On the Connection page, from the Connection Type drop-down list, select REST API Base URL.
2. Do not configure the TLS version.
3. Enter “https://<ofs instance id>.fs.ocs.oraclecloud.com” in the Connection URL field.
4. From the Security Policy drop-down list, select the appropriate security policy. For more information on the supported security policies, refer to the REST Adapter documentation at: https://docs.oracle.com/en/cloud/paas/application-integration/rest-adapter/create-rest-adapter-connection.html
5. Enter the user name and password. Click Test to test the connection.
6. After the connection is tested successfully, click Save.
Configuring Oracle Utilities REST ArcGIS for ArcGIS-OFS Connection
This connection is used to connect to the Tasks feature layer published either on ArcGIS Online or Enterprise Serverusing the REST adapter.
Configure the Oracle Utilities REST ArcGIS for ArcGIS-OFS connection for connecting to the Tasks feature service as REST service on ArcGIS Enterprise Server:
1. On the Connection page, from the Connection Type drop-down list, select REST API Base URL.
2. Do not configure the TLS version.
3. Enter the Tasks feature layer URL in the Connection URL field.
Sample Enterprise Tasks feature layer URL: https://<hostName>:<port>/arcgis/rest/services/ArcGIS_OFS/WorkTasks/FeatureServer/0
4. From the Security Policy drop-down list, select OAuth Custom Two Legged Flow.
a. For Tasks feature layer published as Enterprise Rest Feature Service, on the Access Token Request field, enter the following curl command:
-X POST https://<hostname : port> /arcgis/admin/generateToken -H "Content-Type: application/x-www-form-urlencoded" -d "f=json&username=username&password=password&client=requestip&expiration=120"
Note:
• The username in the above token request URL should be a user with ADMINISTER or PUBLISH privileges. For more information, refer to the documentation at: https://developers.arcgis.com/rest/services-reference/enterprise/generate-admin-token.htm
• Since this API does not return a refresh token, there is no automatic refresh of token when the token expires. To overcome that, set the expirations to a long period. Token expiration period can be set to maximum of one year.
• To regenerate the token again, “Test and Save” the connection and reactivate the integration.
b. In the Optional Security policy add following data:
a. Enter “token” in the $access_token field.
b. Enter “expires” in the $expiry field.
5. Configure the Connectivity agent and click Test.
6. After the connection is tested successfully, click Save.
 
Configure the Oracle Utilities REST ArcGIS for ArcGIS-OFS connection for Tasks feature layer published as Hosted layer in ArcGIS Online:
1. From the Connection Type drop-down list, select REST API Base URL.
2. Do not configure the TLS version.
3. Enter “https://services8.arcgis.com/HwCrARXxqaLxyz/arcgis/rest/services/WorkTasks/FeatureServer/0” in the Connection URL field.
4. From the Security Policy drop-down list, select OAuth Client Credentials.
5. On the Access Token Request URL field, enter the URL.
Sample URL: https://www.arcgis.com/sharing/rest/oauth2/token/
6. Configure the Client ID and Client Secret.
7. In the Optional Security Client Authentication field, select “send client credentials in body”.
8. Click Test to test the connection.
9. After the connection is tested successfully, click Save.
Configuring Oracle Utilities REST ArcGIS Object Storage for ArcGIS-OFS Connection
This connection is used to communicate with Oracle Infrastructure Cloud Object Storage Services using the REST adapter.
Configure the OU REST ArcGIS OS for ArcGIS-OFS connection with required details:
1. On the Connection Properties section, enter the object storage API endpoint in the Connection URL field.
The Connection URL follows this format: https:// objectstorage.{region}.oraclecloud.com
Refer to the Oracle Cloud Infrastructure documentation/API Reference and Endpoints to see the Object Storage Service API and endpoints at: https://docs.oracle.com/en-us/iaas/api/
2. In the Security section:
a. Select the OCI Signature Version 1 security policy.
b. 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)
For more information, refer to the Object Storage Setup Guide 20C at: https:// docs.oracle.com/cd/F35460_01/index.htm
3. After the connection is tested successfully, click Save.