Skip to main content
Aerial grid view of an oilfield, the physical asset whose hierarchy is fragmented across fourteen disconnected software systems
Back to Insights
The ProblemData Architecture

Your Asset Hierarchy Lives in 14 Systems. Your Engineers Are the Integration Layer.

The part no vendor demos: reconciling an asset hierarchy fragmented across SCADA, GIS, ARIES, ERP, and ten more systems. It costs roughly $150K in engineering time before a platform goes live, and most operators pay it again with every new tool.

Michael Atkin, P.EngMay 27, 20269 min read
14
Systems a typical operator's asset hierarchy is fragmented across
$150K
Pre-deployment data-reconciliation burn before a platform goes live
15 min
Reconciled hierarchy pulled from a 600-well operator's own systems, vs. two months of workshops
< 1 week
Data Hub stand-up on existing systems, read-only, no rip-and-replace

Every vendor demo shows you the dashboard. None of them shows you the part that takes two months and $150K before the dashboard ever lights up: reconciling an asset hierarchy that lives in fourteen systems and agrees with itself in none of them. That reconciliation is the real cost of operational software, it is paid in your best engineers' time, and most operators pay it again every time they buy a new tool.


The Problem Nobody Demos: Your Asset Hierarchy Lives in 14 Systems

Ask a mid-sized operator a simple question. Where is the authoritative list of your wells, with the right parent battery, the right facility, the right cost center, and the right surface and downhole equipment attached to each one?

There is no single answer. There are fourteen.

SCADA has a well list, organized by RTU and tag path. GIS has a different one, organized by spatial feature and API number. The reserves system (ARIES) has another, organized by economic entity. The hydraulic model (WinFlow) has another, organized by node. Hyperion has the financial roll-up. The ERP has the cost centers. Production accounting has the allocation network. The EAM has the equipment register. Add the document management system, the compliance platform, the field data capture app, the regulatory reporting tool, and two or three home-grown databases that one person maintains, and you are past fourteen before you have counted the spreadsheets.

None of them agree. The same well is SMITH 1-12H in SCADA, Smith #1-12 in the ledger, 30-025-41872 in GIS, and SMITH A 1-12HX in the reserves model. The parent battery is correct in two systems, stale in two, and missing in one. This is not a data-quality failure by a careless team. It is the predictable result of fourteen systems that were each bought to solve one functional problem and never asked to agree with the other thirteen.

The asset hierarchy is the connective tissue of the entire operation. It is also the single thing no system owns.

Your Engineers Are the Integration Layer

When fourteen systems do not agree and a decision needs all fourteen, something has to reconcile them. At most operators, that something is a person. Usually the most expensive person available.

The reconciliation work looks the same everywhere. An engineer exports a well list from SCADA. Pulls another from the ledger. Drops both into a workbook. Writes a nested VLOOKUP to match SMITH 1-12H to Smith #1-12, hand-corrects the forty that do not match, pulls the GIS coordinates, joins the equipment register, and emails the result to the three people who needed it. Next month a new well comes online, a SCADA tag gets renamed, a battery gets recommissioned, and the workbook is wrong again. So the engineer rebuilds it.

This is the hidden operating model of a great deal of upstream and midstream work. The people you hired to design the next phase, evaluate the next acquisition, or optimize the next gas-lift program are spending a meaningful fraction of their week being the integration layer between systems that should talk to each other and do not. It is the same pattern that makes a hydraulic study at a gas utility cost $15K in loaded engineering time: the engineering is fast, the data archaeology in front of the engineering is what burns the calendar.

It is invisible on any budget line because no one writes a purchase order for it. It is paid in salary, at the top of the pay scale, in two-AM hours that never show up as a project cost.

Get the WorkSync Field Ops Brief

Monthly read for upstream + midstream operations leaders. Case studies, benchmarks, and what's changing in the field. Unsubscribe anytime.

The $150K You Spend Before the Platform You Bought Goes Live

The cost becomes visible exactly once: when you buy a new platform.

Every operational platform, every AI pilot, every analytics initiative needs a clean, reconciled asset hierarchy to run against. So the first phase of every deployment is a data-readiness project. The shape of it is consistent across vendors and across operators:

  • Two to three full-time people pulled off other work for two months.
  • Eight subject-matter experts giving up roughly ten percent of their week to answer "is this the right parent for that well" several hundred times.
  • Outside consultants billing by the hour to run the workshops and assemble the model.
  • And the quietest cost of all: two quarters of deferred value from the platform you already paid for, sitting idle while the data underneath it gets reconciled.

Add it up and the pre-deployment burn lands around $150K before the software you bought produces a single ranked plan or a single decision. The operator experiences this as "the rollout is taking longer than we thought." What is actually happening is that the asset-hierarchy reconciliation that was never done is now being done, on the clock, as a prerequisite to value.

The worst part is that it does not stay done. The workshop produces a snapshot. The operation keeps moving. By the time the next platform arrives, the snapshot is stale, and the $150K gets spent again.

Why Workshops Don't Fix It

The standard fix for a fragmented asset hierarchy is a master-data workshop. Get the right people in a room, agree on the canonical hierarchy, write it down, and publish it as the single source of truth.

The workshop produces an artifact. The operation is a process. That mismatch is why the fix never holds.

A well comes online. A battery is recommissioned. A SCADA integrator renames a tag during a panel upgrade. A gathering line is rerouted. An acquisition closes and four hundred new wells arrive with their own naming convention. Every one of those events makes the workshop output a little more wrong, and none of them generates a meeting to update it. The spreadsheet that was authoritative on Friday is stale by Monday and quietly abandoned by the following quarter, at which point the next workshop gets scheduled.

A single source of truth that is built once and maintained by hand is not a single source of truth. It is a depreciating asset with a half-life of about a quarter.

A Single Source of Truth Is a Process, Not an Artifact

The version that holds is not a document. It is a layer that sits on the systems you already own, reads them continuously in read-only mode, and reconciles the hierarchy as the source systems change. When a SCADA tag is renamed, the layer sees it. When a new well lands in production accounting, the layer maps it. The reconciliation that an engineer used to redo every month happens automatically, all the time, and the canonical hierarchy is never more than minutes behind reality.

This is what the intelligence layer argument has always pointed at, viewed from the data side. The systems below stay authoritative. The layer above makes them collectively legible. It is not a thirteenth place to copy your data into. It is the connective tissue the other fourteen never had.

The connectors that make this work are not custom middleware written from scratch for each operator. They are pre-built against the systems the industry actually runs, across seven categories: production accounting (P2, Quorum, Enverus), EAM (Maximo, SAP PM, IFS), SCADA and historian (OSIsoft PI, Cygnet, Ignition), engineering (AVEVA, Siemens, AutoCAD), documents (SharePoint, OpenText), compliance (Intelex, Sphera), and GIS (Esri, FME). Forty-plus connectors, not a forty-week integration.

The proof is in the turnaround. On one recent deployment, a 600-well operator pulled the reconciled asset hierarchy from its own systems in fifteen minutes: the exact deliverable that two months of workshops and ten-plus people were scheduled to produce. The difference was not effort. It was that the data was read from the source systems directly instead of reassembled by hand in a conference room.

What This Unlocks: AI That Has Somewhere to Live

The asset hierarchy is not a back-office detail. It is the substrate every useful AI capability runs on, and it is the most common reason oil and gas AI pilots stall in the proof-of-concept graveyard.

A model that scores wells by cash flow at risk needs to know which equipment belongs to which well, which well rolls up to which battery, and what each stream is worth. A field agent that captures a pumper's voice note and routes it to the right work order needs the equipment register joined to the well joined to the crew. A pricing or deferment calculation needs the allocation network reconciled to the ledger. None of that is possible on fourteen disagreeing hierarchies. All of it is trivial on one reconciled backbone.

This is why "AI without infrastructure is just expensive noise." The model is rarely the hard part anymore. The hard part is giving it a clean, current, economically attributed view of the asset, and that view is precisely what the fragmented hierarchy denies it. Operators who solve the hierarchy first find their AI deployments work. Operators who skip it find their pilots producing confident answers about wells that do not exist or equipment attached to the wrong battery.

The competitive framing is worth stating plainly, because the gap is widening every quarter. Devon, ConocoPhillips, and APA each spent six to eight years and several hundred million dollars building this backbone internally before their AI programs became line items on the earnings call. The independent operator does not have to repeat that build. The backbone that took a supermajor most of a decade can now be stood up on existing systems in a week. The operators who do it this year compound; the operators who wait keep paying the $150K reconciliation tax and keep watching their pilots stall.

The One-Week Path

The WorkSync Data Hub is the operator-specific version of this argument. It reads production accounting, SCADA, historian, EAM, GIS, engineering drawings, documents, and compliance systems in their native homes, in read-only mode by default, with write-back opt-in per system. Credentials go in on day one. Three integrations are live by day seven. The reconciled asset hierarchy is a running process from then on, not a workshop output that decays.

It is built to operate-grade security: SOC 2, IEC 62443 OT-grade controls, and an on-premise LLM option for operators who will not send operational data off site. WellOPS and FlowSync ride on top of the same backbone, which means the asset hierarchy is reconciled once and every product uses it. The Data Hub is free with any WellOPS or FlowSync module and is also sold standalone. The full side-by-side against the data-lake and unified-namespace patterns is laid out in the Data Lake vs Data Hub vs UNS comparison, and the broader case against the lake-first sequence is in The Data Lake Is a 2017 Idea.

The math against the status quo is not close. The $150K pre-deployment reconciliation is a recurring cost that the operation pays on every new tool and every stale-spreadsheet rebuild. A read-only backbone that stays current pays for itself the first time a platform deploys in a week instead of a quarter, and it keeps paying every time the asset changes and the hierarchy updates itself instead of waiting for an engineer to rebuild a workbook at two in the morning.

The asset hierarchy lives in fourteen systems. It does not have to live in your engineers' heads and their spreadsheets. Stand up a single source of truth on the data you already own, and stop paying the integration tax twice a year.

Frequently Asked

What is an asset hierarchy in oil and gas operations?

An asset hierarchy is the structured map of how an operation fits together: which downhole and surface equipment belongs to which well, which well rolls up to which battery or facility, which facility ties to which cost center, and how each producing entity maps to the economic and regulatory roll-ups. It is the connective tissue that lets a production number, a maintenance event, a safety record, and a dollar figure all be attached to the same physical thing. Almost every operational decision depends on it, and almost no single system owns it.

Why does the asset hierarchy end up fragmented across so many systems?

Each system was bought to solve one functional problem and was never asked to agree with the others. SCADA organizes wells by RTU and tag path, GIS by spatial feature and API number, the reserves system by economic entity, the ledger by cost center, the EAM by equipment register. The same well carries a different name and a different parent in each one. Fragmentation is the predictable result of stacking fourteen point solutions, not a sign of a careless team.

What does pre-deployment data integration actually cost?

The visible cost shows up once, when a new platform is bought. The typical data-readiness phase pulls two to three people full-time for two months, takes roughly ten percent of the week from eight subject-matter experts, adds consultants billing by the hour, and defers two quarters of value from the platform that is already paid for while its data gets reconciled. The all-in figure lands around $150K before the software produces a single decision, and because the reconciliation is a one-time snapshot, the cost recurs with every new tool.

Why do not master-data workshops permanently fix a fragmented asset hierarchy?

A workshop produces an artifact; the operation is a process. A new well comes online, a battery is recommissioned, a SCADA tag is renamed during a panel upgrade, an acquisition lands four hundred wells with their own naming convention, and none of those events triggers a meeting to update the document. The spreadsheet that was authoritative on Friday is stale by Monday and abandoned within a quarter. A single source of truth maintained by hand is a depreciating asset with a half-life of about a quarter.

How is a single source of truth different from a data lake or a master-data project?

A data lake copies data into a parallel storage tier and a master-data project produces a governed model maintained as its own program. A read-only data backbone does neither. It leaves data in the systems of record, reads them continuously, and reconciles the hierarchy as the sources change, so the canonical view is never more than minutes behind reality. The existing systems remain authoritative and there is no thirteenth place to copy data into.

Do I need to clean my data before deploying AI in oil and gas?

Not in the lake-first sense the consultants sell. What AI actually needs is a clean, current, economically attributed view of the asset, which is what a reconciled hierarchy provides. The reconciliation can be a running process on existing systems rather than a multi-quarter cleanup project. Operators who give their models a reconciled backbone find the pilots work; operators who skip it find pilots producing confident answers about wells that do not exist or equipment attached to the wrong battery.

How long does it take to stand up a single source of truth with WorkSync?

The WorkSync Data Hub reads production accounting, SCADA, historian, EAM, GIS, engineering drawings, documents, and compliance systems in read-only mode, with write-back opt-in per system. Credentials go in on day one and three integrations are live by day seven. From there the reconciled asset hierarchy is a running process, not a workshop output that decays. It is built to SOC 2 and IEC 62443 OT-grade controls with an on-premise LLM option, and it is free with any WellOPS or FlowSync module.

Request Your Free Trial. Stand up a single source of truth in one week.

See how WorkSync can transform your operations.

Related Insights

An upstream drilling rig representing the independent operator who can leapfrog the supermajor data-lake sequence with vertical AI on existing SCADA
The Approach

The Data Lake Is a 2017 Idea. Independents Don't Need One to Run AI in Production.

Every independent has heard the same three sentences from a consultant or a hyperscaler partner. We aren't ready for AI. Our data isn't ready. We are still working on governance. That sequence is a 2017 idea. The supermajors stopped paying for it four years ago, and the operating proof points they now cite (ExxonMobil/SLB 2.2% on 1,300+ wells, ConocoPhillips PLOT 30% on 4,500+ wells) ran against the SCADA history the operators already had. The independent that builds a lake in 2026 is paying for a workaround to a problem that no longer exists.

Aerial grid view of oil field operations
The Approach

The Intelligence Layer Your Tech Stack Is Missing

Most operators have invested heavily in point solutions. What is missing is the layer that connects them all and answers what should we work on right now.

Digital hologram visualization of pumpjack operations
The Problem

You Have the Data. You Don't Have the Answers.

Operators have spent millions on SCADA, CMMS, ERP, and production accounting systems. Despite this investment, most field teams still start their day building spreadsheets.

Pipeline and process piping at a gas utility facility, the network a hydraulic study has to model accurately
The Problem

The Million-Dollar Model: Why Gas Utility Planning Teams Still Burn Six Weeks on a Single Hydraulic Study

The average hydraulic study at a North American gas distribution utility costs $15K-plus in loaded engineering time and takes more than two weeks to build. A five-person planning team running the standard loop burns $750K to $1M a year on model maintenance. The math has not changed in 30 years. Closing the loop has.

Digital pumpjack hologram representing AI-enabled operations
The Approach

AI Without Infrastructure Is Just Expensive Noise

Most oil and gas AI projects fail for the same reason: the AI has nowhere to live. You need an operational foundation BEFORE agents can do anything useful. Here are the four layers that matter.

Aerial view of an oilfield at dawn, the asset surface where the 24-hour AI operations diagnostic publishes its first ranked work list by 5:30 AM the next morning
The Approach

Give Us One Day: The 24-Hour AI Operations Diagnostic That Replaces the Six-Month Discovery Phase

The discovery-then-pilot sequence the consulting industry sells is producing decks, not deployments. McKinsey reports 70% of operators are still stuck in pilot phase. Gartner reports 30% of GenAI projects are abandoned after POC. The bar moved while the workshops ran. The 24-hour AI operations diagnostic ingests the operator's SCADA, lease accounting, historian, GIS, and EAM in read-only mode and returns a ranked work list against the operator's own wells by 5:30 AM the next morning. Same vertical-AI substrate that runs the 5,000+ well deployed reference. No license fee, no kill fee, no decks.