Back to all case studies
ITAM · IntegrationHub

ITAM ↔ CMDB Sync Pipeline

Integration developer — API contracts, spoke design, and error handling.

Bi-directional syncReduced data driftAuditable error trail
Problem

Asset data drifted between ServiceNow ITAM and third-party CMDB sources, breaking downstream reports.

Approach

Built REST integrations via IntegrationHub spokes and Scripted REST clients to reconcile assets bi-directionally, with retry logic and structured error logging.

Outcomes
  • Reconciled ~100k assets across ITAM and the external CMDB nightly.
  • Cut CMDB drift-related tickets significantly quarter-over-quarter.
  • Gave the platform team an auditable, queryable error trail per sync run.
Notable details
  • Retry with exponential backoff on 5xx and MID Server timeouts.
  • Coalesce keys tuned per CI class to prevent duplicate insertions.
  • Structured logs written to a custom table for weekly hygiene review.
Stack
IntegrationHubScripted RESTREST/SOAPMID Server
More work