Analytics Path
Governed Insight
→
→
→
Independent medallion processing for reporting, semantic models, data science, and AI.
Unified Analytics + Controlled ERP Synchronization
One Foundation.
Two Business Paths.
See where Microsoft Fabric provides native capability, where an integration bridge is needed, and which ecosystem options close the operational gaps.
OneLakeShared Bronze Foundation
Path AAnalyticsBronze → Silver → Gold
Path BERP SyncDispatch → Worker → Outcome
0Native Fabric CapabilitiesView native coverage →
0Partial Coverage AreasInspect limitations →
0Documented Platform GapsReview gap responses ↓
2Independent Business PathsExplore both paths →
Coverage at a Glance
What Fabric Covers — and Where to Extend
Explicit Gap Register
Where Fabric Needs an Extension
A gap does not mean the architecture fails. It identifies where Fabric needs custom engineering, organizational ownership, Azure services, or a partner product.
Interactive Capability Model
Fabric Coverage & Gap Map
Select a capability to inspect scope, constraints, and recommended ecosystem responses.
Product claims and documented limitations link to their supporting Microsoft Learn or trusted vendor source.
Reference Architecture
Ingest Once. Activate Twice.
Bronze in OneLake is the common handoff point for governed analytics and controlled operational propagation.
Fabric NativePartial CoverageGap / Extension Required
Enterprise Sources
Common Foundation
Path APath B
ERP Synchronization Path
Controlled Action
→
→
Metadata-driven work management with API, RPA, computer-use, or human-assisted destination updates.
Adapted Design Controls
Operational Guardrails
Treat execution as at-least-once. Every destination write needs a stable idempotency key.
Bind each work item to its mapping version so a retry cannot silently adopt a changed transformation.
Prove source intent equals destination state; a worker-reported success is not sufficient evidence.
Use leasing, atomic status transitions, attempt limits, and poison-record handling for competing workers.
Bronze retention and immutable record identifiers must protect dispatch pointers from becoming invalid.
Destination outages, ERP throttling, and queue growth require capacity controls—not only alerts.
Ingestion Pattern Selector
Choose the Simplest Path into OneLake
Work from lowest effort to highest flexibility. Escalate only when latency, transformation, or source support requires it.
Rules of Thumb