Read your ERP nightly. Write to it never.
CONOPS | MOS (Manufacturing Operating System) reads each site's ERP through a linked server into a metadata-driven warehouse. Onboarding a site is configuration, not code: load definitions name the source tables, the change columns and the target datasets.
| Dataset | Rows changed | Duration | Verify |
|---|---|---|---|
| Backlog | 1,204 | 00:41 | Pass |
| Job orders | 3,318 | 01:12 | Pass |
| Purchase orders | 812 | 00:27 | Pass |
| Shipments | 96 | 00:08 | Pass |
| Labor transactions | 9,441 | 02:03 | Pass |
| BOM structure | 0 | 00:05 | No change |
Two ERPs mapped, others scoped
Configuration, not code
Linked server
Your DBA creates a linked server from the warehouse instance to the site's ERP database with a read-only login.
Load definitions
We register the site and its source schema in the metadata tables: source table, key, change column, target dataset.
Initial load and validation
A full load, then row counts and totals reconciled against ERP reports your controller already trusts.
Nightly schedule and verify reports
A SQL Agent job runs change-only loads each night; verify reports confirm counts and flag anomalies.
- Backlog
- Job orders and operations
- Purchase orders
- Shipments
- Bookings
- BOM structure
- Part master
- Customers
- Cost of sales
- Labor transactions
Which module reads which dataset is listed on each module page.
What we check for an ERP we have not mapped
- Access
- Direct SQL access to the ERP database or a replica; linked-server reachability from where the warehouse will run.
- Schema
- Where the ten datasets live, how change is detected (timestamps, row versions or audit tables), and site identifiers.
- Volumes
- Rows per dataset and daily change rates, to size the load window.
- Reconciliation
- Which ERP reports we validate against for backlog, shipments and cost of sales.
- Output
- A written scope and a fixed price for the integration phase, usually within two weeks of access.
Request an ERP fit assessment.
Tell us the ERP and the number of sites. We return a scoped integration phase with a fixed price.