Spensara Spensara Knowledge Base & Documentation Repository

Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)
Built Word Documents (.docx): Spensara Overview (.docx) Capability Assessment (.docx) Brink POS Ingestion Analysis (.docx) The Borg Ingestion Architecture (.docx)
architecture/c4/docs/C4/etl/integrations.c4 1,438 bytes · Updated Oct 23, 2026 10:44 AM EDT
Raw File
views 'ETL / Integrations' {
  // =========================================================================
  // ETL Integration Use Cases
  // =========================================================================

  view brinkpos_integration {
    title 'Brink POS Integration - API Pool'
    description '
    Concrete use case: Real-time order and inventory data from Brink POS.
    ETL Worker polls the Brink API on a schedule, validates payloads,
    transforms into warehouse-ready files, and loads into tenant Redshift.
    Data flows through staging into curated tables for monitoring.
    '

    include brinkpos.**
    include kdsai.etl.etlWorker
    include kdsai.etl.rawStorage
    include kdsai.etl.loadStorage
    include kdsai.warehouseDb
    include kdsai.etl.curatedStorage

    autoLayout TopBottom
  }

  view kds_debezium_integration {
    title 'KDS Integration - Debezium CDC'
    description '
    Concrete use case: Change data capture from KDS database via Debezium.
    Debezium captures all changes to kitchen orders and items,
    streams CDC events to ETL Worker which transforms and loads into Redshift.
    Enables real-time kitchen state synchronization for monitoring.
    '

    include kdsdebezium.**
    include kdsai.etl.etlWorker
    include kdsai.etl.rawStorage
    include kdsai.etl.loadStorage
    include kdsai.warehouseDb
    include kdsai.etl.curatedStorage

    autoLayout TopBottom
  }
}