Integration engineering

SQL, APIs — and the systems that have neither.

Every system holds a piece of the truth. Some hand it over through an API. Some through SQL. Some through a 1990s data file with no documentation and a vendor who'd rather you didn't ask.

We get the data out of all three — and keep it flowing.

350+
Tables mirrored live from one ERP
16 s
Mirror hot cycle (was 3 min)
5 min
TMS mirror freshness
20+
Platform APIs in production
Interconnectivity

Your system of record in the middle. Everything else talking to it.

Storefronts, marketplaces, carriers, accounting, payments, EDI partners, the shop floor — reading from and writing to the same source of truth, automatically. Platforms we've wired together in production, not a partner logo wall.

ERP, TMS & back office

COBOL-era ERPs (Vision / AcuCOBOL)ODBC bridgesSage IntacctSalesforceRevenova & Salesforce-based TMSPostgres / Supabase mirrors

Commerce & marketplaces

BigCommerce — retail storefrontsBigCommerce — B2B wholesale portalsFaire — orders in, tracking outShopifyAmazonEmail marketing platforms

Freight, shipping & EDI

UPS WorldShip & APIs1,200+ carriers detectedLTL rating & BOL automationEDI X12 850 / 855 / 856 / 810 / 875 / 880 / 997TriumphPayFMCSA safety dataProject44 tracking

Money

StripeAuthorize.Net (bridged & migrated)ACH mandatesPlaid bank feedsLevel 2 / Level 3 card dataBank Positive Pay files

Floor & devices

Keyence date codersFilling & packaging machinesZebra label printersRaspberry Pi edge fleetSensors, PLCs & MQTT

Communication & documents

Microsoft 365 / GraphGoogle Workspace / GmailOCR document intakePush alertingPrint-path automation
SQL & data platforms

One queryable source of truth. Finally.

We build the mirror, always: a Postgres platform (usually Supabase) holding a live, complete copy of your ERP, TMS, and CRM data — synced every few minutes, shaped for questions, locked down per tenant.

That's what makes the dashboards, the commission engines, the churn detection, and the AI agents possible. It's also what makes them trustworthy: every number traces back to a row.

350+
Tables mirrored from one ERP
16 s
Hot cycle (was 3 min)
8,500/s
Rows, measured bulk loader
16
Self-healing views, one TMS platform

What "data platform" means here

  • Sync loops that paginate everything — no silent row caps, no partial pictures — with watermarks, backoff, and cross-worker locks.
  • Materialized views refreshed after every sync, validated against raw data, and self-healed on drift.
  • Row-level security and tenant scoping enforced in the database from a verified JWT — one remediation contained 218 tables of accidental exposure.
  • Curated + raw layers — typed tables for humans and dashboards; an auto-discovered raw layer so nothing in the source is unreachable. A 7-million-row seed loads in about 15 minutes.
  • Migrations and DDL run with check-and-backup discipline; collisions get renamed aside, never dropped.
  • Immutable journals for money-bearing data — attribution, commissions, payments — so audits reconstruct, not guess.
  • Vault-encrypted credentials for every upstream system; nothing in plaintext, nothing in logs.
APIs we speak

Built and operated in production. Quirks included.

Every one of these has a documented API and an undocumented personality. We've met both.

Salesforce & Salesforce-based TMS

SOQL at scale, Tooling and Data APIs, Flow webhooks, client-credentials auth isolation, managed-package reverse engineering, near-real-time sync loops. Freight page →

Sage Intacct

REST and XML, multi-entity, AR/AP/GL, budgets, invoices, vendor bills, payment writeback — and the bridge takeover when the last vendor's integration died.

BigCommerce

Retail storefronts and B2B wholesale portals: catalog, pricing tiers, customer groups, orders into the ERP, promotions, shipping rules, abandoned-cart recovery.

Faire & Shopify

Wholesale marketplace orders created in the ERP automatically, penny-exact net pricing, packing slips, tracking and costs pushed back — OAuth apps and brand tokens.

Stripe, Authorize.Net & Plaid

Gateway migrations and a protocol bridge, billing, webhooks, ACH mandates, Level 2/3 data, bank-feed reconciliation. Stripe page →

UPS, carriers & EDI

WorldShip imports and exports, UPS Rating and label APIs, tracking across 1,200+ carriers, LTL rating and BOL generation. Our own X12 engine parses and generates 850, 855, 856, 810, 875, 880, and 997 over SFTP with a per-partner control plane.

TriumphPay, FMCSA & freight platforms

Payment-rail sync with JWT lifecycle management, FMCSA safety refresh across a whole carrier book, Project44 tracking, carrier status feeds parsed into customer events.

Microsoft 365 & Google Workspace

Graph and Gmail APIs: inboxes that route freight, POs, and invoices themselves; message-ID dedup that survives humans; document intake; audit-safe automation.

Devices & edge

Keyence date coders, filling machines, Zebra printers, Raspberry Pi fleets — sensor and machine data into the same platform as everything else. Manufacturing page →

ERP ↔ commerce interconnectivity

Orders in. Fulfillment out. Money and paperwork both ways. One system of record.

The pattern below runs today for a multi-channel food manufacturer whose ERP is a COBOL-era system with no API. If it works there, it works on yours.

DIRECTION
FROM → TO
WHAT MOVES
Orders in
Faire, BigCommerce retail, BigCommerce B2B portal, EDI 850, email POs → ERP
Orders created automatically in the ERP through its own import programs — customer matched, SKUs mapped, pricing and handling rules applied, no re-keying.
Fulfillment out
ERP → WorldShip, label printers, pick sheets, carriers
Shipments staged from ERP data, labels and pre-labels printed in warehouse sequence, routing guides enforced per retailer.
Tracking back
Carriers → Faire, storefront, EDI 856, customer email
Tracking numbers, carriers, and costs written back to every channel automatically — the thing that gets brands paid faster.
Money
Stripe, ACH, pay links ↔ ERP AR, bank feeds
Card and ACH collection tied to invoices; payouts reconciled to deposits; wholesale accounts auto-charged on terms; marketplace net pricing computed per line so the ERP ties to the payout to the penny (93 of 93 lines verified).
Paperwork
ERP → EDI 810, batch invoice email, portals
Invoices batched, sent, confirmed, and filed without a human babysitter; documents OCR'd on the way in.
Catalog & inventory
ERP ↔ storefronts, marketplaces, planning
SKUs, pricing tiers, promotions, and availability kept honest across channels; demand flowing into planning instead of spreadsheets.

Every arrow above ships with a watchdog. Heartbeats, freshness checks, reconciliation sweeps — and when a feed breaks, an AI monitor diagnoses it, drafts the fix, and emails a GO/NO-GO button. How that works →

How we work

Read-only first. Parallel-run always. Cut over on evidence.

We never write to a live system of record until the read side is proven and the write side has run in the shadows. Every integration gets a validation campaign, a written gate, monitoring from minute one, and a human approving every step that changes something real. It's slower than a demo. It's faster than a rollback.