Configuration Properties
The OUTL-BRT-ArcGIS_WACS_ConfigProps lookup contains the properties that can be defaulted in the integration. It also contains a flag to enable email notifications.
Property Name
Sample Value
Description
Used in Integration Process Name
wacs.file.target.transfer.pref
os
Defines the WACS file location preference.
 
Valid values: os|ftp
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
wacs.os.namespace
wacsnamespace
WACS Object Storage namespace serves as a container for all WACS related buckets and objects.
 
Required to be populated when WACS is in the cloud, wacs.file.transfer.pref = 'os'.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
wacs.os.bucket.assetsync
ArcGIS_AssetSync
Define the bucket name where the Asset Sync extract files should be dropped in the WACS Object Storage by OIC.
 
Required to be populated when WACS is in the cloud, wacs.file.transfer.pref = 'os'.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
wacs.ftp.directory.assetsync
/scratch/AcrGIS_AssetSync
WACS FTP directory where the Asset extract files are dropped by OIC.
 
Required to be populated when WACS is on-premises, wacs.file.transfer.pref is = 'ftp'.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
notification.type.email.flag
true
If the value is set to 'true', email notification will be sent out for errors.
 
Valid values: true|false
 
Default: true
OU WACS OIC GISMappings Sync
OU ArcGIS WACS Assets Sync
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
notification. email.process.complete.flag
true
If the value is set to 'true', email notification will be sent when Asset files have been created and dropped in the respective location.
 
Valid values: true|false
 
Default: true
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
wacs.projectedcoordinates ystem.wkid
4326
This property is used to configure the coordinates system [wkid] which will be used to retrieve the geometry coordinates in the specified system format.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
sync.initial.maxresult.count
2000
Defines the maximum number of query results (features) the ArcGIS query API can fetch per invocation. When this number exceeds the maxRecordCount , it is defaulted to maxRecordCount. maxRecordCount is represented by the “Maximum Number of Records Returned by Server” parameter on Enterprise server manager.
 
Note: This value must be equal or less than the value of “Maximum Number of Records Returned by Server” setting found on the Parameters page for each Service Layer in ESRI ArcGIS Server Manager. Exceeding this number can result in incomplete synchronization.
 
References:
 
OU ArcGIS WACS Initial Assets Sync
sync.increment.objectid.count
1000
Defines the maximum number of objectIds to be queried. This is passed to the ObjectIds parameter in the ArcGIS query API.
 
Note: For performance, ESRI recommends keeping this value below 1,000 records.
 
Reference:
OU ArcGIS WACS Incremental Assets Sync
arcgis.retry.wait.time
5
Seconds to wait before each retry attempt.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
arcgis.retry.count
3
Maximum number of retry attempts on timeout.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
arcgis.retry.error.codes
503, 500
Comma-separated ESRI internal error codes that indicate an error that needs to be retried, returned within a 200 HTTP response, and will trigger a retry.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
arcgis.retry.error
true
Flag that enables or disables retry on error.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
wacs.files.per.run
300
ApplyEdits performs with a maximum records of 200 to 300 records per invoke. This configurable number is done on the WAM side.
OU WACS ArcGIS Assets Update
arcgis.version.name
CustomerVersion
Customer Integration Version Tag
OU WACS ArcGIS Assets Update
wacs.ftp.fileLocation
/scratch/assetUpdates/
Folder in FTP location where WACS files will be dropped.
OU WACS ArcGIS Assets Update
wacs.os.bucket
AssetsUpdate
Bucket in Object storage location where WACS files will be dropped.
OU WACS ArcGIS Assets Update
wacs.file.prefix
WACS_
File prefix to be used on the files dropped by WACS.
OU WACS ArcGIS Assets Update
wacs.file.prefix.processed
PROCESSED_
Prefix used to rename successfully synced files.
OU WACS ArcGIS Assets Update
wacs.file.prefix.error
ERROR_
Prefix that will be used to rename failed file when there is any type of error when decoding the content or when sending novelties to ESRI.
OU WACS ArcGIS Assets Update
 
The OUTL-BRT-ArcGIS_WACS_Email_ID lookup contains the properties that can be defaulted in the integration. It also contains a flag to enable email notifications.
Property Name
Sample Value
Description
Used in Integration Process Name
from
ArcGIS_WACS@email.com
Defines the ‘from’ email address on the notifications.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
OU Common Notification Handler
to
errorDist@myCy.com
The email address(es) who should receive any error notification. Multiple emails can be configured by putting comma to separate the email IDs.
 
These are likely the administrators or users who maintain the applications.
OU WACS OIC GISMappings Sync
OU ArcGIS WACS Assets Sync
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
to.process.notification
bizDist@myCy.com
The email address(es) of who should receive notification when the processing has completed. Multiple emails can be configured by including comma to separate the email IDs.
 
These are likely the business or application users.
OU ArcGIS WACS Initial Assets Sync
OU ArcGIS WACS Incremental Assets Sync
OU WACS ArcGIS Assets Update
 
The OUTL-BRT-ArcGIS_WACS_AssetClass lookup contains the assets that are configured in Oracle Utilities Work and Asset Cloud Service and are located in ESRI ArcGIS. It also contains customizable columns that relate to ESRI ArcGIS locations.
This lookup is primarily refreshed by the OU WACS OIC GISMappings Sync integration and adapted to the customer ESRI ArcGIS implementation.
Column Name
Sample Value
Description
Comments
AssetClass
Pump_Centrifugal
Name of the Asset stored in WACS.
Updated by the synchronization flow.
Attributes
LIFECYCLESTATUS,GLOBALID
Attributes associated with the asset
Updated by the synchronization flow.
Query
 
 
 
RelativeURI
relative1/FeatureServer/501
URI from this asset feature. It has to end as: /FeatureServer/{ID}
ID after the FeatureServer is required to be retrieved in the ESRI ArcGIS portal.
 
Note: RelativeURI cannot end with a “/”.
ServerId
S1
ESRI ArcGIS portal instance
Used to direct to the appropriate configured connections documented in Chapter 4: Importing, Configuring, and Testing Integration Connections.
The OUTL-BRT-ArcGIS_WACS_DateTimeFields lookup contains the ArcGIS dateFields coming from Oracle Utilities Work and Asset Cloud Service that will be transformed to ESRI ArcGIS DateTime field types. If a Feature Layer ID is provided, it will only be transformed on that layer; else, it applies to all layers.
Column Name
Sample Value
Description
Comments
ArcGISFields
INSTALLDATE
Name of the field in the incoming payload that will be evaluated, matched, and transformed to an equivalent value in the target DateTime field in ESRI.
OU WACS ArcGIS Assets Update
ArcGISDataType
esriFieldTypeDate
ESRI target data type to which the field from WACS will be matched and transformed.
OU WACS ArcGIS Assets Update
FeatureLayerId
515
If multiple fields with the same name are published on different layers in ESRI with different data types, this attribute controls the transformation for each layer. If left empty, the same data type transformation logic is applied to all layers containing the field name.
OU WACS ArcGIS Assets Update