UT Integrator

A GIS within utilities needs to be integrated with a number of other important, if not mission critical IT systems within utilities. Typical systems to be integrated are:

  • Enterprise Resource Planning systems (ERP), like SAP
  • Customer Relationship Management systems (CRM)
  • SCADA and DMS systems

The UT Integrator offers three types of integration:

  • Backend integration – synchronization of databases
  • Frontend integration – calling the graphical user interface of the remote system
  • GUI integration – combining functions of both systems in one web GUI

 

Backend Integration

UT Integrator offers real-time integration with other databases at the level of the UT data model based on ArcGIS for Server. Dependent of your business logic, either the GIS or the remote IT system (e.g. SAP) may be the leading system.

A wide variety of different adaptors and interfaces in both directions is available. The following inbound and outbound interfaces towards remote systems are available:

  • SOAP / XML
  • SAP specific (e.g. IDOC, RFC)
  • Table reader
  • CSV file reader

The SOAP / XML interface is a widely used interface. This interface may also be used to integrate with other Enterprise Buses (e.g. WBI, Biztalk, SAP PI etc.). For certain integration use cases, also the table reader or CSV file reader interfaces are useful tools. Especially when integrating with SCADA systems, typically the ASCII-based interface is used.

 

Frontend Integration

A very elegant and easy method of creating smooth, web-based workflows is to simply call the user interface (GUI) of the other IT system.

This means, that the UT JavaScript Web client can be opened, and the end-user may select directly via the map certain assets (e.g. stations). Subsequently he may open the respective masks in SAP / PM to create a new maintenance order or a notification for these stations. Or he may simply examine this particular functional location within SAP / PM. This also works the other way around: SAP users may click on a button in their SAP mask and be placed directly into the correct geographic location within the GIS Web Client.

This frontend integration requires the databases of GIS and SAP to be referenced to each other through backend integration.

GUI Integration

AED-SICAD developed specific expertise in integrating SAP masks and GIS maps and functionality into one web-based window. This allows end users to access within a certain role and a certain business process only those SAP and GIS functions and data which they really need in this very moment.

The databases of the respective systems (SAP / GIS) are accessed directly, no duplication of e.g. GIS database is required.

The front-end is built with state-of-the-art web technology, i.e. JavaScript / HTML 5. This type of front-end integration gives a completely new freedom of designing efficient business processes.

Example: Find downstream customers by executing the UT Server tracing functions and creating a shutoff notification within SAP – all within one web user interface!