You are here

Systems Integration

Significant ROI can be achieved by integrating your GIS data to other surrounding systems. SSP has worked with utilities across the U.S. to design integrated workflows between GIS and many common utility systems including the following: Systems Integration

  • Enterprise Asset Management (EAM): Many utilities use their GIS as their sole asset management system but many more have an external dedicated enterprise asset management system. SSP has created custom bi-directional integrations between Esri/Schneider Electric GIS and other asset management modules including IBM Maximo, Oracle WAM, Oracle EAM, and is currently working on integrations to the JD Edwards Fixed Asset module and Cascade. Most often these interfaces allow for assets to be created within the GIS and then passed into the external system as a linked record. Asset lifecycle events can then be shared between the systems including inspections, maintenance, retirement, and attribute updates.
  • Customer Information System (CIS): This is perhaps our most common integration point to the GIS. Allowing data to flow from your CIS into your GIS automatically can provide many benefits. The custofmer records can be linked to service locations on the map which will drive customer spatial analysis applications, reporting, and synchronized workflows. The GIS may also be used to pass spatial coordinate data back into the CIS where it may be used for other purposes such as meter connects/disconnects, work order dispatch, etc. This data may also then feed into an OMS (see below) as part of the GIS spatial data. SSP has built integrations to various CIS systems including Indus Banner, Northstar, and several homegrown mainframe CIS applications.
  • Work Management System (WMS): SSP has integrated GIS to WMS systems across many different graphic design packages and different WMS implementations. Since our partnership with Schneider Electric has developed, most of these integrations are built to the Schneider Electric Designer™ graphic design application. In the past, SSP has integrated Designer™ to Logica WMIS, Severn Trent STORMS, IBM Maximo CU Estimating (CUE), a number of homegrown WMS applications, and is currently working toward integrations to both Oracle WAM and Oracle EAM. SSP utilized this extensive knowledge of WMS integration to build our own tight integration to Schneider Electric Designer™ within our own Workforce Management (WFM) product. This has allowed us to create a best-of-breed implementation for users of our product line along with the Schneider Electric Designer™ solution.
  • Distribution Planning System (DPS): DPS systems allow engineering groups to plan for expansion and to conduct load flow analysis on their distribution networks using specialized programs outside of the GIS. The challenge is to get the connected geometric network data out of the GIS and into the DPS in a format that is compatible with the external program. SSP has built several different integrations using both custom approaches and utilizing Schneider Electric Network Adapter as the foundation. The most common DPS systems SSP has worked with include GL SynerGEE (gas & electric), ABB FeederALL (electric), and Innovyze InfoWater.
  • Inspection Management: Many utilities use external vendors or contractors to conduct their annual facility inspections. SSP has been challenged to build integrations between the GIS and several other inspection management programs. The formats for these systems range from text-based exports to Esri shapefiles to personal geodatabases. SSP has worked with Osmose FastGate, TC Technologies, Schneider Electric ArcFM Viewer™ for Engine, and custom ArcPad solutions.
  • Outage Management System (OMS): As utilities embrace new technology, one of the key tools they realize immediate benefit from is an OMS. This software allows them to manage incoming outage or trouble calls, run predictive analysis to determine network failure points, to dispatch crews and manage the incidents through completion. Many of these OMS applications depend on the GIS to feed them valid connected data. In many situations, the GIS data is exported and loaded into the OMS on a batch basis. SSP has built exports into ABB CADOPS and Survalent OMS, and has worked directly with Schneider Electric Responder™ (which natively utilizes the GIS data).
  • Accounting - Plant Accounting / General Ledger: Through our work building the SSP Workforce Management product and through several other GIS engagements, SSP has learned the ins and outs of capturing data for use in a variety of accounting formats. Often we've been responsible for tracking compatible unit codes for each asset type which are also tied to FERC, CPR, and/or plant account codes. We are then able to track data based on installations and retirements and to subsequently export either transaction-level/summary-level reports or raw data exports that can be consumed by an accounting system. This data is used to update Continuing Property Records (CPR), the General Ledger, and/or the Cost of Work in Progress (CWIP).
  • Document Management System: Great value can be added to the GIS by allowing GIS features to be linked to an external document management system. This can sometimes be as simple as using a hyperlink to get to a specific directory or file but can be much more complex when using a document management system API to query and access the document libraries. SSP has worked with a wide range of custom document management systems as well as Documentum - AppXtender/WebXtender and assorted Microsoft SharePoint document management add-ons.
  • Engineering Analysis (EA): While the EA tools within the GIS are continually improving, many utilities still leverage external toolsets to perform EA. These exports are usually very similar to the DPS exports and are based on utilizing the connected geometric network within the GIS. SSP has performed both custom (direct) exports and has used Schneider Electric Network Adapter to export the data. A common example destination is the Milsoft Windmil package.
  • Interactive Voice Recognition (IVR): Most utilities utilize an IVR system to capture customer trouble calls for outages or other incidents. The IVR usually validates against a CIS record and then captures the call into a database. An integration can be built from the IVR into the GIS / OMS to allow for the call to be automatically utilized within an outage. During SSP's implementations of Schneider Electric Responder™, we've integrated to several different IVR systems to accept calls into the GIS including Centurion IVR and IfByPhone IVR.
  • SCADA: These systems track real-time device events on a utility network and can inform the back office when those events occur. SSP has integrated to several SCADA systems to display SCADA status within the GIS and to feed the SCADA events into the Schneider Electric Responder™ OMS product. Specifically, SSP has integrated to the Schneider Electric OASyS SCADA and OSI SCADA.