Service line · API & System Integration

Data that arrives once,
correctly, and on time

We connect the platforms your operation runs on — ERP, CRM, payroll, accounting, warehouse and field systems — through an integration layer that retries on failure, quarantines what it cannot process and tells someone when it stops. The objective is not more connections but fewer surprises at month end.

0
Sync success rate across managed pipelines
0
Median time to detect a failed sync
0
Point-to-point connectors consolidated into one hub
0
Manual re-entries required at month end
Why these projects start

Problems we are usually called in to fix

Integration failures rarely announce themselves. They surface as a figure that does not agree between two systems, usually days after the cause.

A nightly job fails and nobody finds out for a week

A scheduled export feeds another process. When it stops — a password expired, a disk filled, a field renamed — the only symptom is absent data.

Duplicate records appear after a retry

A request times out, the caller sends again, and the receiving system creates a second invoice. Without idempotency handling a transient fault becomes a data-quality problem.

Two systems disagree and neither is obviously wrong

The CRM reports a different revenue figure to the ERP. Both are internally consistent; they apply different rules about when an order is earned, and nothing documents the difference.

A vendor upgrade breaks a connector silently

A provider deprecates a field and the integration keeps running while writing blank values. Contract tests would have caught it at release; nothing was watching.

Scope of work

What this service covers

Integration work divides into building exchanges, replacing fragile ones and adding governance. We scope each separately so you can choose where to start.

API design and build

Versioned REST and event-driven interfaces with authentication, rate-limit handling and documented contracts.

API patterns →

Connector replacement

Retiring point-to-point scripts in favour of one governed layer with shared error handling.

On integration debt →

Reconciliation and reporting

Scheduled comparisons that report variance by record, so a discrepancy can be traced to the transaction that caused it.

Why it matters →

Monitoring and on-call

Health checks, alert routing and a documented escalation path. We treat a silent failure as a severity-one defect.

Response targets →
How we approach it

Four stages, from inventory to on-call

Integration projects fail when they start with code rather than an inventory. We establish what exists before changing anything.

01

Interface inventory

We catalogue every exchange: source, destination, trigger, payload, owner and failure mode. Most clients are surprised by the count. The inventory is the baseline for everything that follows.

02

Contract definition

For each exchange we record the agreed shape of the data, which side owns which field and what happens to an invalid record. Ambiguity here produces duplicate and partial records later.

03

Pipeline build

Exchanges are implemented with idempotency keys, bounded retry with backoff and a dead-letter queue. Held payloads are inspectable and replayable, so recovery needs no database script.

04

Parallel run and cutover

The new pipeline runs alongside the old one until reconciliation agrees across a full cycle including a month end, after which the old connector is disabled and kept available for rollback.

Representative engagement

An integration programme

Described by sector only.

Operations analyst reviewing a data reconciliation report on screen
Integration · Mining Services

Fourteen connectors reduced to one hub

A Perth-based mining services contractor was moving mobilisation data, timesheets, purchase orders and equipment hours between an ERP, a CRM, a payroll platform and two departmental spreadsheets. Fourteen connectors had accumulated over a decade, three with no identifiable author. Failures surfaced when payroll figures did not reconcile, two days before a pay run. We inventoried every exchange and built a single hub with shared retry and quarantine behaviour.

.NETPythonAzure Service BusSQL ServerTerraform
99.9%
Sync success rate
6 hrs
Weekly reconciliation saved
14 → 1
Connectors in production

Read the full case →

Engineering detail

The mechanics that make an exchange trustworthy

These mechanisms are present in every integration we ship. Without them an interface is reliable only until the first unusual condition.

Idempotency keys

Every write carries a key derived from the source record. A repeated delivery updates rather than inserts, so a retry cannot produce a second invoice.

Dead-letter queues

Payloads that fail validation or exhaust retries move to a quarantine queue with their error context intact. An operator can replay a record without a developer.

Exponential backoff

Transient faults are retried on an increasing schedule with jitter, so a brief vendor outage does not produce a retry storm.

Schema versioning

Payload contracts carry an explicit version and are validated on receipt. A vendor change produces a visible validation error, not a field quietly arriving empty.

Reconciliation reports

Each night the pipeline compares source and destination control totals, reporting variance by record. The report goes to a named recipient.

Contract tests

Automated tests assert the agreed shape of every payload. A vendor release that breaks an assumption fails the build before deployment.

Indicative bandA$18k – A$95k

Integration programme

Inventory, contract definition, build, parallel run and cutover. Scales with exchange count and source data condition.

  • Fixed price per exchange after inventory
  • Ongoing monitoring from A$950 per month
  • Excludes GST
  • Excludes vendor licence and API fees

Indicative only, based on programmes delivered since 2021. A single documented REST exchange sits at the lower end; consolidating a decade of connectors sits at the upper end.

What you receive

Handover pack

The engagement ends with documentation your team can operate from. Each item is produced during delivery and reviewed before cutover.

  • Interface inventory with owners
  • Payload contracts and versions
  • Field-level ownership matrix
  • Retry and quarantine policy
  • Reconciliation report specification
  • Alert routing and escalation table
  • Replay and recovery runbook
  • Contract test suite in the repository
  • Parallel run evidence and sign-off
Common questions

Practical answers before you commit

Our ERP has no modern API. Is that a blocker?

Rarely. Many mid-market platforms expose only a database view, scheduled export or SFTP drop. We design around what exists and state the limitations so you can weigh them.

Do you replace everything at once?

No. Exchanges migrate in a sequence ordered by risk and value, with the old connector disabled only after a successful parallel run.

Who is alerted when a pipeline fails?

Whoever you nominate, by the channel you nominate. We confirm the arrangement with a deliberate test failure before go-live.

How do you handle sensitive data in transit?

Transport is encrypted, credentials sit in a managed secret store, and payloads are logged as identifiers where personal information is present.

What does ongoing support look like?

Most clients continue on a monitoring arrangement covering health checks, alert response in AWST hours and a monthly reconciliation review.

Find out what your interfaces are actually doing

We start with an inventory. You will have a clear picture of every exchange before any build is proposed.

Get a Quote