AI Executive Office — CXO Assistant Platform  ·  View 09 of 30  ·  3 · Structure

Integration Catalogue

Every way the platform touches another system, with protocol, cadence and direction — including the two it is allowed to write to.

Editable source SVG draw.io All views
Consumers Teams app Executive web Tenant console Audit export Power BI Integration layer API Management north–south Data Factory batch + CDC Eventstream event in Logic Apps action out Self-hosted IR on-prem reach Source and target systems ERP and finance Procurement Projects HR and CRM Supply chain Document estate Workflow engine Teams and email Bot HTTPS · SSE admin API signed same measures OData CDC REST r/w REST hourly nightly events Graph delta approved Graph send Integration Catalogue — Every Interface In and Out Application we own External / third party Interface / broker Queue / topic synchronous batch event / async Fourteen interfaces, four cadences. Mobile shares the web contract; the existing lake is mounted as a OneLake shortcut rather than copied. Only procurement and the workflow engine are written to, and only after an approval. v 1.0 · owner Data & AI Global Practice · date 2026-09

Decisions

  • Read integrations are pulled on a declared cadence rather than pushed. A source that pushes is welcome to, but the platform never depends on it, because a missing push is invisible and a missing pull is an alert
  • The existing lake is mounted as a OneLake shortcut rather than copied. Copying a customer's warehouse into the platform doubles the storage bill and creates a second version of the truth
  • Writes exist on exactly two interfaces. Every other arrow out is a notification

Numbers

  • Fourteen interfaces at go-live; the prototype takes three (ERP/finance, procurement, projects)
  • Cadences: seconds (events), 15 minutes (finance CDC), hourly (projects), 4-hourly (documents), nightly (HR, CRM, market)
  • Each interface carries a freshness contract, and the answer states which one it used

Risks

  • Legacy public-sector ERPs frequently have no CDC capability. The fallback is a nightly full extract, which changes what "what changed since yesterday?" can honestly mean — and the answer must say so
  • The workflow engine write is the highest-blast-radius interface in the platform. It is the one with a dedicated connector identity and a re-check at execution time (view 20)