Enterprise Integration5 min read

Decide master data ownership before you connect systems

Most integration conflicts are ownership conflicts. A short method for assigning the system of record for customers, products, prices and stock before the first connector is built.

By IT NET Solution

Two systems both claim to hold the customer's address. Both are updated by people doing their job correctly. Synchronising them in both directions produces a loop of overwrites that nobody can explain a week later.

The fix is not a tool. It is a decision: for each domain of data, one system is authoritative and others hold a copy. Copies may be enriched locally, but never overrule the source.

A workable method

  1. 01

    List the domains, not the fields

    Customer, product, price, stock, order and invoice. Field-level debates are easier once the domain owner is settled.

  2. 02

    Choose the owner by process

    The owner is the system where the data is created and corrected as part of daily work — not the system with the nicest interface.

  3. 03

    Define what copies are allowed to change

    Local additions are fine; local edits to authoritative fields need a request path, or the copy will drift.

  4. 04

    Publish the contract

    Write the owner, direction of flow, refresh timing and escalation into the integration documentation everyone already reads.

The uncomfortable cases

Prices are usually split: list prices live in the ERP, commercial agreements live in the CRM. Stock may be owned by the warehouse system while the website needs a near-real-time view. These are not failures of the model; they are places where the model needs a rule and a staleness tolerance, stated explicitly.

Topics

  • Master data
  • Architecture
  • ERP
Related service: Enterprise Integration

Working on something similar?

Describe the systems, the constraints and what needs to change. We will outline a realistic path and the trade-offs behind it.