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 Utilities 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
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.
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. On the Connection page, enter the user name and password.
Note: As part of user name and password, provide the ClientID and Client Secret (you can retrieve them from the Oracle Field Service environment).
5. Click Test at the upper-right corner to test the connection.
6. 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.
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 a generic connection to connect to Tasks, Activities, and ActivityAssets feature layer published either on ArcGIS Online or Enterprise Server using the REST adapter.
If the Tasks, Activities, and ActivityAssets feature layer are published as rest services on standalone ArcGIS Enterprise Server configure the connection with the following 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://<hostName>:<port>/arcgis/ in the
Connection URL field.
4. From the Security Policy drop-down list, select OAuth Custom Two Legged Flow.
a. 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. This number is represented in minutes.
• 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.
7. When running any of the OU ArcGIS OFS Work Tasks Process, OU OFS ArcGIS Activities Delete, or OU OFS ArcGIS Activities Sync flows, make sure the integration property is set with the correct relative URI. This relative URI is the part of the feature layer URL after /rest/services/.
Example: A feature layer URL for Tasks layer may look as follows:
https://exampleOrghost:6443/arcgis/rest/services/ArcGIS_OFS/WorkTasks/FeatureServer/0
The Relative URI will be: /ArcGIS_OFS/WorkTasks/FeatureServer/0
8. The Integration properties pertaining to relative URIs is configured in the OU ArcGIS OFS Work Tasks Process, OU OFS ArcGIS Activities Delete, or OU OFS ArcGIS Activities Sync flows.
Example:
• For the Work Tasks Process flow, set workTasksLayerRelativeURI = "/WorkTasks/FeatureServer/0".
• For the Activities Delete flow, set activitiesLayerRelativeURI = "/Activities/FeatureServer/0".
If the Tasks, Activities, and ActivityAssets feature layers are published as hosted layers 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://<org server root>/arcgis” 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.
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.
10. When running any of the OU ArcGIS OFS Work Tasks Process, OU OFS ArcGIS Activities Delete, and OU OFS ArcGIS Activities Sync flows, make sure the integration property is set with the correct relative URI. This relative URI is part of the feature layer URL after /rest/services/.
Example: A feature layer URL for Activities layer looks as follows:
https://services10.arcgis.com/xyz/arcgis/rest/services/Activities/FeatureServer/0
Relative URI will be: /Activities/FeatureServer/0
11. Integration properties pertaining to relative URIs is configured in the OU ArcGIS OFS Work Tasks Process, OU OFS ArcGIS Activities Delete, or OU OFS ArcGIS Activities Sync flows.
Example:
• For the Work Tasks Process flow, set workTasksLayerRelativeURI = "/WorkTasks/FeatureServer/0".
• For the Activities Delete flow, set activitiesLayerRelativeURI = "/Activities/FeatureServer/0".
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)
3. After the connection is tested successfully, click Save.
Configuring Oracle Utilities REST Asset ArcGIS for ArcGIS-OFS Connection
This connection is used to connect ESRI ArcGIS Field Maps to get the asset information to retrieve the assets based on gisID. This connection corresponds to ArcGIS Enterprise Server connection where the Utility dataset is published from a Enterprise geodatabase.
Example: Water, Electric dataset
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://<hostName>:<port>/arcgis/rest/services/<folder-name>/ FeatureServer in the
Connection URL field.
4. From the Security Policy drop-down list, select OAuth Custom Two Legged Flow.
a. 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. This number is represented in minutes.
• 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.