Work and Asset Cloud Service to Geographic Information System Integration - File Based Synchronization Process

The new file-based synchronization process works with any Geographic Information System (GIS) vendor to load Geographic Information System data into Oracle Utilities Work and Asset Cloud Service. This process requires the data to be in GeoJSON newline-delimited format and uses fewer batches to create or update asset and asset locations in Work and Asset Cloud Service. GIS File Upload (W1GISUPL) batch control has been introduced to create composite sync requests from the GeoJSON newline-delimited file. Asset and asset location are either created or updated from the composite sync requests. Compared to the Legacy Geographic Information System Integration, this new process requires fewer batches to complete the synchronization.

Additionally, this release includes a W1-GISIntegrationConfiguration admin sync API. This API provides the Geographic Information System to Oracle Utilities Work and Asset Cloud Service mapping information needed for file-based integration with external systems.

This process works with any Geographic Information System vendor and simplifies the workflow by requiring fewer batches to create assets and asset locations in Oracle Utilities Work and Asset Cloud Service.

Steps to Enable

To enable this feature, refer to the GIS File-Based and Legacy GIS Documentation for more information.

Tips And Considerations

The GIS File Upload batch control is secured by the GIS File Upload (W1GISUPL) application service.

Access Requirements

System administrators should grant Execute access to the GIS File Upload (W1GISUPL) application service to any user that will run the batch control.