Leveraging Oracle Integration Cloud for Two-Way Data Flow Between Maximo & Oracle Field Service

The Challenge

Like many utilities navigating ongoing modernization efforts, the client engaged HEXstream to better manage its work, assets, and workforce.  The proposed single platform solution would benefit both the organization's Electricity Transmission & Distribution division and its Natural Gas Transmission & Distribution division.

HEXstream partnered with industry-leading field service implementer Group7 Consulting.

Using Oracle Integration Cloud (OIC) to integrate data from Maximo, Oracle Field Service (OFS), Cornerstone, and ESRI GIS, HEXstream helped the utility reduce manual, paper-based processes and automate timecard processing.

About the Client
  • Natural Gas and Electricity divisions of a publicly-traded Canadian engineering, logistics, and energy holding company
  • Over 1 million natural gas customers
  • Over 200,000 electricity customers

What We Built

OFS Integration with Maximo

The utility sought a cloud-based mobile work force management solution to improve how the business managed its assets, work, and workforce. The implemented scheduling and dispatching tool leveraged the Enterprise Asset Management system (IBM Maximo) as the key integration point with Oracle Field Service for asset tracking and field activity information.  In addition, the application leveraged data from Cornerstone for competency and resource skill data to improve routing and dispatching, also providing users with links into the ESRI GIS system to provide relevant additional data.

The real-time bidirectional flow of data between Oracle Field Service and Maximo relied on OIC.  The newly-automated real-time integration brought together Maximo's scheduling capabilities and OFS's field resource data.  This included integration with Oracle Autonomous Data Warehouse (OADW) and customizations within OIC.

Custom Reports & Dashboards

With all the data coming together, HEXstream gained the ability to provide the client with real-time insights into their transactional information rather than just sharing batch data at the end of each day.  Further, this has helped the client analyze and identify trends in their resource usage in various conditions.

Through this partnership, HEXstream and Group7 Consulting have helped the client utility lay the foundation for ongoing dashboard & analytics development.  By continually refining data operations and making data available throughout the organization, the client stands to derive more value from its data than ever before.

How can we help your utility manage and analyze data more effectively? Ask the utilities analytics experts! 

Let's Talk!

Back to Blog

Related Articles

Digitalizing Outage Management Ops for a Publicly-Traded Power Utility

The Challenge After enduring several record-breaking storms throughout the 2010s, the client...

Integrating 4 Outage Management Systems Into a Single Analytics Platform

The Challenge After embarking on an aggressive growth strategy, the client utility made several...

Generating Reliability Reports 8x Faster After the Acquisition

The Challenge In the midst of an acquisition by a larger, multi-state investor-owned utility, the...