Azure
Data & Analytics
intermediate
Enterprise Data Warehouse — Azure Architecture Template
Data Factory ELT from operational SQL through a staging lake into a Synapse warehouse for enterprise reporting.
Why this architecture works
- ELT via the lake keeps source extracts cheap and lets Synapse do set-based transforms at scale
- Staging in ADLS Gen2 decouples extraction cadence from warehouse load windows
- Data Factory integration runtime isolates source connectivity from the analytical plane
- Warehouse access uses workspace identities; source credentials live only in Key Vault
- Pipeline run history and Synapse DMV metrics feed Log Analytics for freshness SLA tracking
What's inside (7 resources)
Source SQL
sql-server
ELT Pipelines
data-factory
Lake Storage
storage-account
Staging Lake
data-lake-gen2
Warehouse
synapse-workspace
Secrets
key-vault
Logs
log-analytics-workspace
From template to running infrastructure
- Open this template in the CloudForge visual designer (free account, no credit card).
- Customize resources, names, and connections on the drag-and-drop canvas — or ask Vani, the AI architect, to adapt it.
- Generate production-ready Terraform, ARM, or Bicep in one click.
- Review the plan diff and security scan, then deploy with human approval.