Choose a source of truth for each object rather than one system for every data item.
ERP, MES, and WMS Integration: What Data Should Flow?
A reliable architecture gives every system a clear role, owner, and boundary.
Use explicit business events instead of context-free table synchronisation.
Every interface should be idempotent, observable, and reconcilable.
Design exception paths with the same care as the happy path.
The role of each system
Integration problems often begin when two systems believe they own the same data. Clear boundaries simplify design and prevent uncontrolled two-way updates.
| System | Primary ownership |
|---|---|
| ERP | Sales orders, purchase orders, work-order planning, finance, costing, customer, supplier |
| MES | Dispatch, WIP, operation results, material consumption, quality events, genealogy |
| WMS | Receipts, locators, inventory status, movement, allocation, pick, pack, shipment |
Define the data contract before the API
An API is a transport mechanism, not a business definition. Before choosing REST, webhooks, queues, or files, agree on objects, identifiers, owners, required fields, validation, timing, versions, and error handling.
The data contract should also say whether an update is a command, event, or snapshot. “WorkOrderReleased” is more meaningful than sending an entire work-order table every five minutes.
- A unique correlation ID to trace one transaction across systems.
- An idempotency key so retries do not create duplicate transactions.
- Version and effective dates for master data, BOMs, routes, and revisions.
- Event and processing timestamps for latency analysis.
Original example: work order to shipment
ERP releases a work order with model, quantity, due date, BOM reference, and routing reference. MES validates the revision and converts it into dispatchable work.
WMS receives a material reservation or pick request based on actual demand.
During production, WMS confirms material issue, MES records consumption and output, then sends operation completion and finished-goods receipt. ERP receives completion quantities and the business transactions it needs.
ERP
WorkOrderReleased and planning context.
MES
Dispatch, execution, WIP, quality, and consumption.
WMS
Material issue, movement, FG receipt, and shipment.
ERP
Completion, inventory valuation, costing, and invoicing.
Retries, reconciliation, and observability
Integration is not successful merely because an endpoint returns HTTP 200. The business transaction must be correctly recorded in the target system and be verifiable.
Monitoring should show success rate, latency, pending messages, failures, retries, and business reconciliation. Use a dead-letter queue or exception board with an owner and next action.
PRACTICAL NOTEReconciliation example: material issue in WMS should match the consumption received by MES for the same correlation ID and quantity.
Security and interface change
Apply least privilege, credential rotation, TLS, audit logs, and segmentation according to risk. Do not expose a production database merely to accelerate the first integration.
Field and business-rule changes require versioning and regression testing. Interfaces without an owner become difficult technical debt.
Questions before moving forward.
This article combines TEKADA operating-system design experience, simplified original implementation examples, and references from standards bodies and research institutions. Examples do not claim a specific customer outcome.
References used.
Common questions.
Does every integration need to be real-time?+
No. Choose event-driven, near-real-time, or batch based on business impact, volume, reliability, and reconciliation needs.
Can ERP connect directly to machines?+
It may be technically possible, but using MES or an integration layer often provides better context, governance, and scalability.
When is middleware useful?+
Middleware becomes useful when mapping, retries, routing, security, monitoring, and interface changes are difficult to manage through point-to-point connections.
Need help applying this in your operation?
Discuss the process, data, and systems behind your current challenge.
Need help applying this strategy?
Connect this insight with your company’s processes, data, technology, and implementation priorities.
