RSC Topic: Data Integration & Interoperability

ERP, MES, PLM, QMS, and supplier system mapping and synchronization.

  • AutomationML

    AutomationML (Automation Markup Language) is an open, XML-based data exchange format used to describe and exchange engineering information for automation systems. It is primarily applied to model production equipment, control systems, and their relationships so that different engineering and manufacturing IT tools can share a consistent view of the plant.

    What AutomationML includes

    AutomationML commonly represents:

    • Physical structure of production systems, such as machines, cells, and lines
    • Control logic objects and signals, including PLC-related information
    • Topology and connectivity between devices, networks, and interfaces
    • Attributes needed for integration with higher-level systems, such as MES, SCADA, and engineering tools

    Technically, AutomationML is a container format that combines several established standards, such as CAEX for plant topology, COLLADA for geometry, and PLCopen XML for control logic. This allows different engineering disciplines to work with a shared model while using their own specialized tools.

    Where it is used in manufacturing

    In industrial operations, AutomationML is used as a neutral data model to:

    • Exchange equipment and automation engineering data between design tools from different vendors
    • Support virtual commissioning, line simulation, and offline testing based on a common plant model
    • Provide structured information about assets and signals that can be mapped to MES, ERP, SCADA, or OPC UA-based systems
    • Help maintain an up-to-date digital representation of the automation layer in complex or frequently modified plants

    In regulated environments, AutomationML may be part of the technical underpinnings for documented system integration, data lineage, and traceability between shop-floor automation and higher-level information systems.

    Relation to other integration standards

    AutomationML is often used alongside other standards rather than replacing them:

    • OPC UA: OPC UA provides a runtime communication and information modeling framework; AutomationML typically represents engineering-time models that can be mapped into OPC UA address spaces.
    • ISA-95 / IEC 62264: ISA-95 defines functional and data models between enterprise and control levels; AutomationML can describe the detailed automation objects that ultimately support ISA-95-based integrations.
    • B2MML: B2MML is an XML implementation of ISA-95 for business-to-manufacturing integration. AutomationML focuses more on engineering and automation assets, which can be linked to B2MML-based enterprise and MES data structures.

    Common confusion

    AutomationML is:

    • Not a communication protocol like OPC UA or Modbus; it is a data format and modeling approach.
    • Not an MES or SCADA system; it is used by such systems and engineering tools to exchange structured models.
    • Not limited to a single vendor or toolchain; it is intended as an open, vendor-neutral representation.

    Context from ISO 22400 usage

    When plants adopt KPI standards such as ISO 22400, AutomationML can help by providing a structured description of equipment, signals, and automation objects that underlie KPI calculations. This engineering model can then be mapped to MES, ERP, and SCADA data so that KPI definitions are consistently tied to actual tags, resources, and production assets.

  • How are key characteristics identified and tracked in digital FAIRs?

    In a digital FAIR, key characteristics are identified and tracked by combining controlled definition at the source (drawing/PLM), structured ballooning, and traceable inspection data capture. The details vary by software and plant maturity, but the core pattern is consistent.

    1. Identifying key characteristics

    Key characteristics are typically flagged before or during FAIR creation using one or more of these approaches:

    In practice, this connects to digital AS9102 FAI when teams need to turn the answer into repeatable execution habits.

    • From the drawing/PLM model: The engineering authority defines which dimensions or notes are key (e.g. via drawing symbols, layer conventions, GD&T feature flags, or PLM attributes). A digital FAIR tool then imports these and maps them into FAIR characteristics.
    • During digital ballooning: While ballooning the drawing, the planner or quality engineer assigns a status (e.g. key, critical, major, minor) on each ballooned characteristic using standard codes or checkboxes.
    • From routing / control plan: Some sites maintain key characteristics in control plans or routers. The FAIR system links the plan to the part and auto-marks matching FAIR characteristics as key.
    • Manual override with governance: Where legacy drawings are inconsistent, users can manually mark key characteristics, usually restricted to specific roles and tracked via audit trail.

    The accuracy of key characteristic identification depends on drawing standards, PLM configuration, and how disciplined planners are in maintaining those flags. Many plants run hybrid processes while they improve data quality.

    2. Structuring key characteristics inside the digital FAIR

    Once identified, key characteristics are represented explicitly in the FAIR record, typically as:

    • Dedicated fields/flags: Each characteristic line item has a boolean or categorical field (e.g. KC = Yes/No, severity class, characteristic type).
    • Standardized codes: Drop-down values aligned with internal procedures or AS9102 guidance (e.g. safety-critical, flight-critical, functional key, process control).
    • Linkage to requirement source: References back to drawing balloon ID, feature ID, specification, or PLM requirement ID so that the KC can be traced through design changes.
    • Association to process step or operation: The key characteristic is tied to specific machining, assembly, or inspection operations in the routing, which enables downstream tracking in MES or digital travelers.

    For regulated environments, the configuration of these fields usually goes through change control and validation to ensure consistent, repeatable use across programs and suppliers.

    3. Tracking measurement and results for key characteristics

    Tracking in a digital FAIR is primarily about how measured values and dispositions for key characteristics are captured and kept traceable:

    • Structured data entry: For each key characteristic, inspectors enter actual values, tools used, and results (pass/fail) into defined fields, not free text.
    • Direct gage/CMM integration (where available): Measurement systems can push data into the FAIR record using mapping rules that align feature IDs to FAIR characteristics. This reduces transcription error but requires careful interface validation.
    • Evidence attachments: For high-risk KCs, scanned CMM reports, capability studies, or photos are attached and linked to the specific FAIR characteristic line.
    • Disposition linkage: If a key characteristic is out of tolerance, the FAIR record is linked to NCR/MRB workflows so there is end-to-end traceability from KC to nonconformance and disposition.

    The robustness of tracking is constrained by metrology integration, data mapping quality, and how well inspectors are trained to use the digital system.

    4. Maintaining visibility across lots, revisions, and suppliers

    Digital FAIRs can provide ongoing visibility for key characteristics across parts and time, but only if the data model is set up correctly:

    • Revision-aware records: The same key characteristic can be traced across drawing revisions using persistent IDs or PLM requirement IDs, with the FAIR clearly tied to a specific revision.
    • Lot/serial traceability: Each FAIR instance links the key characteristic to lot numbers and/or serial numbers, enabling trend analysis and targeted containment.
    • Supplier vs in-house views: For supplier FAIRs, key characteristic information may be imported via portals or standardized templates. Misaligned numbering or ballooning schemes between supplier and OEM are common failure modes and need explicit governance.
    • Analytics and monitoring: Over time, key characteristics can be monitored for defect rate, rework, and capability, but this requires consistent coding and clean master data across programs.

    In many brownfield environments, this level of visibility is achieved gradually, starting with a limited set of programs or suppliers and then expanded once processes stabilize.

    5. Integration with PLM, MES, ERP, and QMS

    Key characteristic tracking does not live only inside the FAIR tool in most plants. Coexistence with legacy systems is the norm:

    • PLM/engineering source of truth: Design intent and KC identification usually originate in PLM or drawing systems. Without stable PLM attributes or drawing conventions, digital FAIRs often rely on manual KC marking, which is less scalable.
    • MES / digital travelers: Key characteristics can be embedded in digital travelers so that in-process inspections focus on them. The FAIR then consumes these results or references them, avoiding double data entry.
    • ERP linkages: Part numbers, revs, and lot information must align. Mismatches lead to KCs being tracked against the wrong configuration or order.
    • QMS / NCR systems: When a key characteristic fails, the QMS handles the NCR, MRB, CAPA. The FAIR system should reference these records for traceability, not attempt to replace QMS functionality.

    Full replacement of PLM, MES, or QMS with a FAIR tool is rarely realistic in regulated aerospace environments due to validation burden, downtime risk, and integration complexity. Digital FAIRs usually sit alongside existing systems and exchange key characteristic data via governed interfaces.

    6. Governance, validation, and common failure modes

    Because key characteristics are often safety- or performance-critical, their digital handling requires explicit controls:

    • Governance: Clear ownership of KC definition (engineering), implementation (manufacturing/quality), and maintenance (data/admin). Role-based permissions to add, change, or remove KC flags.
    • Validation: For aerospace and similar contexts, interfaces that import KCs from PLM or metrology systems and the rules that map them to FAIR records should be documented, tested, and periodically reverified.
    • Change control: When a drawing or model changes, a controlled process should ensure that KC flags, ballooning, and FAIR templates are updated consistently and that obsolete KCs are not reused incorrectly.

    Common failure modes include:

    • Key characteristics not consistently flagged on drawings or in PLM, leading to gaps in the FAIR.
    • Manual renumbering or re-ballooning that breaks links between measurements and KC definitions.
    • Suppliers using different numbering schemes, making OEM analytics on key characteristics unreliable.
    • Attempting to centralize everything in the FAIR tool without aligning PLM, MES, and QMS, resulting in conflicting sources of truth.

    7. Practical implementation steps

    For plants moving from paper to digital FAIRs in a brownfield environment, a pragmatic approach is:

    1. Standardize how KCs are indicated on drawings and/or in PLM for new or revised parts.
    2. Configure the digital FAIR system with explicit KC fields, codes, and audit trails.
    3. Pilot digital ballooning on a constrained set of parts, validating KC import and tracking against existing paper FAIRs.
    4. Integrate with metrology and MES only where interfaces can be reliably mapped and supported, rather than trying to cover all equipment immediately.
    5. Continuously review defects and NCRs on KCs to improve both the digital configuration and the underlying process.

    The result, when done incrementally and with proper governance, is a digital FAIR process where key characteristics are reliably identified, measured, and traceable without disrupting existing qualified systems.

  • What is ISA‑95 standard?

    ISA‑95 is an international standard that defines models and terminology for integrating enterprise systems (such as ERP and planning) with manufacturing operations and control systems (such as MES, SCADA, and equipment controls). It provides a reference architecture for how information should flow between business and manufacturing layers, but it is not an out‑of‑the‑box solution or a compliance guarantee.

    What ISA‑95 actually defines

    ISA‑95 focuses on a few core areas:

    In practice, this connects to data mapping and system interoperability when teams need to turn the answer into repeatable execution habits.

    • Functional hierarchy: A layered model (often mapped to Levels 0–4) that distinguishes enterprise planning, manufacturing operations management, and control.
    • Manufacturing operations domains: Standard categories such as production, quality, inventory, and maintenance operations.
    • Information models and objects: Standardized concepts and relationships for equipment, materials, personnel, work definitions, schedules, production performance, and more.
    • Interfaces between levels: Guidance on what information is exchanged between ERP and MES and how it should be structured.

    The goal is to reduce ambiguity when different systems and vendors need to exchange data about orders, recipes, equipment, materials, and production results.

    What ISA‑95 does not guarantee

    Using ISA‑95 language or reference models does not, by itself:

    • Ensure systems from different vendors will interoperate without custom integration.
    • Remove the need for detailed interface specifications and mapping work.
    • Guarantee any regulatory outcome or audit result.
    • Replace the need for validation, change control, and documentation in regulated environments.

    Actual interoperability depends on how consistently each system implements ISA‑95 models, how clearly data is mapped across systems, and how well integrations are engineered and maintained.

    Why ISA‑95 matters in regulated, brownfield environments

    In most regulated plants, you are dealing with a mixed stack of legacy ERP, MES, historians, and point systems. Replacing everything to achieve a clean ISA‑95 implementation is rarely practical due to qualification burden, downtime risk, and integration complexity.

    Instead, ISA‑95 is typically used to:

    • Create a common vocabulary across IT, OT, quality, and operations for equipment, materials, orders, and production events.
    • Structure integration projects so ERP–MES–control interfaces are designed around a standard model instead of ad‑hoc mappings.
    • Guide master data and reference data design for things like product definitions, work centers, and resources.
    • Support traceability and genealogy by giving a consistent way to describe the relationships between lots, equipment, personnel, and process steps.

    In brownfield plants, adoption is usually incremental: you map existing concepts to ISA‑95 models where practical, rather than forcing every legacy system to conform fully.

    Key tradeoffs when applying ISA‑95

    • Abstraction vs. reality: The standard is generic. Complex, high‑mix, or highly customized operations will not fit the models perfectly. Deviations need to be explicit and documented.
    • Implementation cost: Aligning ERP, MES, and control data structures to ISA‑95 requires modeling work, interface redesign, and testing. This cost is ongoing as products, routes, and systems change.
    • Validation and change control: In regulated environments, any change to ISA‑95‑based interfaces, data models, or mappings must go through formal change control and, where applicable, validation and requalification.
    • Partial adoption: Many plants selectively adopt ISA‑95 concepts (for example, for equipment or material models) while leaving other areas legacy. This can be effective, but it reduces the benefits of a fully consistent model.

    How ISA‑95 coexists with existing standards and systems

    ISA‑95 usually coexists with:

    • Existing ERP schemas: Product, BOM, and work center structures may be only loosely aligned with ISA‑95. Mappings and transformation logic are typically needed at integration points.
    • MES and historians: Older MES and historian systems may have their own naming, equipment hierarchies, and event models. ISA‑95 often becomes the neutral reference model used in an integration layer.
    • Other standards and frameworks: Plants may also be working with standards related to cybersecurity, quality management, or data integrity. ISA‑95 mainly addresses functional and data integration, not security or quality system requirements.

    The practical approach is to use ISA‑95 as a design and governance reference for new interfaces and system changes, while recognizing that complete standardization across a long‑lived brownfield stack is rarely achievable.

  • Data Silo

    A data silo is a set of data that is isolated within a specific system, department, site, or application so that it is difficult to access, combine, or govern from elsewhere in the organization. In manufacturing and industrial operations, data silos commonly arise between OT and IT systems, between plants, or between core platforms such as MES, ERP, PLM, QMS, and maintenance systems.

    Key characteristics

    • Isolated access paths: Only a limited group, system, or site can readily access or change the data.
    • Lack of standardized structure: Data is often stored in proprietary formats, local spreadsheets, or custom databases that are not aligned with enterprise data models.
    • Minimal integration: Little or no automated exchange with other operational or business systems; interfaces, if they exist, are partial or point-to-point.
    • Local governance: Rules for data quality, security, and retention are applied locally rather than through a coordinated enterprise process.

    Where data silos appear in manufacturing

    • System silos: An MES storing detailed as-built data that is not synchronized with ERP, PLM, or QMS, limiting traceability across the full product lifecycle.
    • Functional silos: Quality, production, maintenance, and supply chain each keeping separate databases or spreadsheets for defects, downtime, or shortages.
    • Site silos: Individual plants running local applications or historian databases that are not visible to corporate operations, engineering, or compliance teams.
    • File-based silos: Work instructions, test results, and audit evidence kept in shared folders, email, or desktop files without structured links to work orders or part numbers.

    Operational impact

    Data silos affect how quickly and reliably teams can answer cross-functional questions, such as linking nonconformances to specific lots, understanding true capacity across plants, or demonstrating end-to-end traceability. They can lead to duplicate data entry, inconsistent master data, and fragmented audit trails when events in one system are not reflected in others.

    In regulated or aerospace and defense environments, data silos are particularly relevant when integrating MES, ERP, PLM, and QMS, setting up traceability and genealogy, or preparing evidence for internal and external audits.

    Common confusion

    • Data silo vs. system of record: A system of record is a designated authoritative source for a given dataset. It becomes a silo only when the data is not appropriately accessible or integrated with other systems that need it.
    • Data silo vs. security controls: Security requirements such as export controls or ITAR may restrict who can access certain data. This is not the same as a silo; a secured system can still participate in well-managed, compliant data integration.

    Ties to integration and interoperability

    Work on data integration and interoperability, such as aligning ISA-95 style models, standardizing identifiers (part numbers, work orders, equipment IDs), and using APIs or message buses, often explicitly aims to reduce data silos. In practice this includes connecting MES to ERP and PLM, consolidating OT historian data into accessible repositories, and defining shared master data so that shop-floor events can be combined with quality, supply chain, and financial information.

  • How tightly should MES and ERP be integrated for program cost tracking?

    Short answer: usually “selectively tight,” not fully coupled

    For program cost tracking, MES and ERP typically need consistent identifiers and reliable periodic data exchange, not a fully unified real‑time system. MES should provide trustworthy records of material consumption, labor, and key process parameters at the level of work orders, lots, or serialized units, while ERP remains the system of record for financial valuation and program roll‑ups. In regulated environments, over‑tight integration can increase validation scope, failure modes, and change control overhead without improving cost accuracy proportionally. The practical target is tight integration around master data and transactional keys, and controlled, often batched, integration for detailed execution data.

    What truly needs tight integration for cost tracking

    The most critical area for tight alignment is shared master and reference data: part numbers, BOM structures, routings, work centers, cost centers, and program or contract identifiers. If MES and ERP do not share stable keys for work orders, lots, and serialized units, cost allocation will be error‑prone regardless of integration frequency. For program cost tracking, it is also important that MES records can be unambiguously linked to ERP constructs like WBS elements, contracts, or internal program codes. This kind of tightness is more about data modeling discipline and governance than about technology bandwidth or message volume.

    In practice, this connects to data mapping and system interoperability when teams need to turn the answer into repeatable execution habits.

    Where loose or periodic integration is usually sufficient

    Most programs do not require second‑by‑second or even minute‑by‑minute cost visibility; daily or shift‑based updates are often enough, especially when tied to financial closing cycles. Material consumption details, labor capture, and scrap reasons can usually be transferred from MES to ERP in summarized form by work order, operation, or lot at defined intervals. This reduces integration complexity and validation effort while still supporting accurate standard vs. actual variance analysis at the program level. In many brownfield plants, this approach also aligns better with existing batch jobs, manual reconciliations, and limited integration infrastructure. Attempting fully granular, continuous synchronization often exposes data quality issues and inconsistent business rules that the organization is not ready to handle.

    Tradeoffs of very tight, real‑time integration

    Real‑time bidirectional integration can support near‑instant variance tracking and more dynamic program management, but it significantly increases integration and validation burden. Every data mapping, transformation rule, and error‑handling path becomes part of the validated landscape, and any change requires careful regression testing and documentation. High‑frequency integration can propagate bad data faster, making it harder to identify the true source of cost distortions. In aerospace‑grade or similar environments, a tightly coupled MES–ERP stack can also lengthen outages and complicate recovery because both systems must remain in a consistent, traceable state. These tradeoffs often outweigh the marginal benefit of sub‑daily cost visibility for most programs.

    Constraints in brownfield, regulated environments

    In mixed‑vendor, legacy MES/ERP landscapes, the cost of deep integration is often dominated by data readiness and process inconsistency rather than technology alone. Long‑lived assets and qualified processes mean that replacing or heavily reshaping MES or ERP for the sake of cleaner integration is rarely realistic. Instead, organizations typically layer integration interfaces, staging tables, and reconciliation reports around existing systems, accepting some degree of latency and manual control. Validation expectations, especially where electronic records support released product, limit the appetite for frequent integration changes. This reality argues for a pragmatic integration level: strong around key identifiers and aggregation logic, but conservative around scope and update frequency.

    Practical integration patterns that usually work

    A common pattern is to have ERP generate work orders and cost‑bearing structures, then distribute those to MES with the necessary identifiers and routing context. MES executes the operations, records actuals (labor, material, scrap), and periodically sends summarized postings back to ERP—often on operation close, order close, or at end of shift/day. Some plants add intermediate reconciliation layers, where MES data is staged, checked for completeness and consistency, and then posted into ERP through controlled interfaces. This pattern supports traceable, auditable cost flows without requiring both systems to be in continuous lockstep. It also limits the blast radius of integration failures because postings can be queued, corrected, or replayed under change control.

    When tighter coupling is justified

    Tighter, closer‑to‑real‑time integration may be justified for highly dynamic, high‑value programs where small schedule or yield changes materially affect margins or contractual performance. Environments with mature data governance, standardized routings, and robust integration platforms are better positioned to benefit from tighter coupling without losing control or increasing validation risk. Even there, the tightness should be targeted: for instance, frequent updates of key progress and yield indicators, but not necessarily every sensor reading or operator action. Before tightening the link, it is important to prove that existing cost rolls are stable and that stakeholders can act on more frequent data. Otherwise the organization assumes more technical risk without meaningful gain in program control.