Faster integrations using Master Data Models

Описание: In this episode, Kevin Jones and David Schultz break down how to make integrations of data systems faster using a neat approach with master data models. They have abstracted the master data model into a common database, to allow the master data model to have value beyond ERP and Level 4 systems — pushing them into Level 2 SCADA platforms like Inductive Automation Ignition.

We all know data governance, abstraction, and a single source of truth matter for IT directors, enterprise architects, and plant automation teams. This video shows you a way to actually execute those concepts.

You’ll get:
A refresher on equipment models with ISA-95 role-based standards
Abstract data models in SQL so any system can consume them
A simple process to consume the master data model into Ignition for UDTs to accelerate integration and reduce engineering effort

This capability can: Simplify mergers & acquisitions with consistent models across plants. Reduce time-to-decision with structured, trusted data

👉 Whether you’re in IT, OT, or engineering, this episode will help you design scalable, flexible architectures that eliminate data silos and speed up digital transformation.

🔔 Subscribe for more on UNS, DataOps, MES, and Industry 4.0 architectures.

📑 Episode Outline (with chapter markers)
0:00 – Intro – Why this matters for manufacturing IT & OT

1:00 – What is a Master Data Model? – Beyond ERP into Levels 2–3

3:00 – Why it matters – Flexibility, scalability, single source of truth

5:00 – Who cares most? – IT directors, enterprise architects, automation engineers

6:30 – Functional architecture overview – Where master data fits in (previous video mentioned Functional Manufacturing Systems Architecture)

8:00 – Applying ISA-95 equipment models – Role-based equipment explained

10:30 – Database schema design – SQL as abstraction layer

13:30 – UDT definition in Ignition – Building reusable equipment templates

17:00 – Populating the equipment model – Example with enterprise/site/line hierarchy

20:00 – Mapping UDTS and tags – Defining properties and parameters

22:30 – Example: CNC machine models – Core UDTs and OEM variations

25:00 – Ignition demo – Instantiating the master data model in SCADA

28:00 – Benefits recap – Faster integration, governance, M&A readiness

30:00 – Wrap-up & next steps – Future topic: process modeling