App tier Microsoft Fabric Real-time intelligence Consumers Data flow
MICROSOFT FABRIC Fabric workspace boundary APP TIER · REACT PODS Web App Booking · Active trip Customer + Ops console FABRIC · OLTP SQL Database Operational source of truth Rides Trips Fleet Telemetry Fares STREAM Eventstream SQL CDC → KQL FABRIC · RTI KQL Database Streaming analytics store Event log Rollups CONSUMER Real-time Dashboard writes REST · JDBC KQL USERS Customers Dispatchers CONSUMERS Ops analysts Exec KPIs UNIFIED STORAGE OneLake · single copy, shortcut-shared between SQL and KQL
DATA FLOW
01
Capture
Web app posts bookings, trip events, fare meter ticks to the API.
02
Persist
Writes land in the Fabric SQL Database (OLTP source of truth).
03
Stream (CDC)
Eventstream tails SQL change-feed and publishes to KQL.
04
Index
KQL Database ingests events with sub-second latency for queries.
05
Visualize
Real-time Dashboard renders KPIs, maps, heatmaps, alerts.