Over a million developers have joined DZone.

Integrating Legacy Datasets and Data Sources to Solve Business Problems

DZone's Guide to

Integrating Legacy Datasets and Data Sources to Solve Business Problems

Having integrated legacy datasets and data sources eliminates data silos, reduces time, and increases efficiency.

· Big Data Zone ·
Free Resource

The open source HPCC Systems platform is a proven, easy to use solution for managing data at scale. Visit our Easy Guide to learn more about this completely free platform, test drive some code in the online Playground, and get started today.

Thanks to Chris Holly, Head of IS for IGas Energy for sharing his experience and insight using M-Files and Esri to meet the document management requirements for ISO 9001 and 14000 or a legacy business with more than 25 years of business documents spread throughout the organization.

When Chris was challenged to develop a document management system for ISO 9001, he thought beyond the initial requirement and saw IGas really needed a business process management tool. The vision was to improve business processes by identifying where improvements can be achieved through the use of technology, standardizing and streamlining processes, nurturing an improvement mentality, and ensuring a consistent quality approach across all areas of the business.

IGas was already using M-Files for document management since it did not require Chris to have developers on site. He identified Esri as his GIS solution and information management tool and used M-Files with ESRI to gain access to information from different silos of data making the user experience (UX) better for everyone.

IGas is now using M-Files and Esri to:

  • Build a master table addressing 25 years of naming taxonomies.
  • Track maintenance on well sites to perform predictive and preventive maintenance.
  • Manage all authorizations for expenditures (AFEs) so a user can get an approval in the same day rather than waiting a week or two.
  • Monitor expenses versus AFEs.
  • Click on the GIS interface to see all of the documentation for every site.
  • Manage environmental and regulatory compliance.
  • Keep track of all of the documentation needed for numerous regulatory authorities IGas must report to.
  • Automate operations reporting.

This integration and creative use of two solutions to solve numerous use cases helped IGas offload three business-siloed applications with others on the horizon. Most of the functionality has been built through GUIs. Chris is confident developers who understand the M-Files and Esri tool boxes can get much more out of the software than he is, though it has already added significant business value to the organization.

For the future, Chris sees he and his team continuing to improve business processes by mobilizing the workforce and putting standard operating procedures and risk assessment into the hands of everyone in the field, thus making them more proactive with maintenance and a more environmentally friendly company.

Managing data at scale doesn’t have to be hard. Find out how the completely free, open source HPCC Systems platform makes it easier to update, easier to program, easier to integrate data, and easier to manage clusters. Download and get started today.

big data ,datasets ,legacy data ,data integration

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}