Back to portfolio

Workato and NetSuite: sync divergence lab

A CRM sends thirty billing events to an ERP through an integration layer. Inject failures, then switch on safeguards one at a time. Each safeguard fixes a different kind of divergence, and none of them fixes everything.

Scenario

Failures to inject

Dropped deliveries

Duplicate deliveries

Delayed deliveries

Safeguards

Idempotency keysThe ERP remembers each event id and ignores repeats. Ordered per accountSequence numbers per account. Stale deliveries are discarded. Retry with dead-letter queueUp to four attempts, then the event is parked and visible. Reconciliation jobCompares both systems after the run and repairs differences.

Outcome

Event stream, in the order the ERP handled it

Applied Applied late Duplicate applied Blocked Lost silently Dead-letter queue Repaired

Letters: I is an invoice, C is a credit, A is a plan amendment. Hover a chip for details.

Accounts: CRM versus ERP

Account	CRM balance	ERP balance	CRM plan	ERP plan	Status

Balance drift before any repair

What the diff shows

Salesforce, Workato, NetSuite and other product names are trademarks of their respective owners. This page is not affiliated with or endorsed by any vendor.

Back to portfolio