Skip to content
ADL Docs
Get Started Concepts Using the App Templates Reference

Data Vault Physical Data Warehouse — SQL Server

The Physical Data Vault SQL Server starter solution implements a Data Vault architecture using physically materialized tables on SQL Server. Unlike the virtual approach (which uses views), this sample generates actual tables for the integration and presentation layers.

This design is suited to scenarios where performance or data volume requires materialized storage rather than on-the-fly view computation.

The sample includes metadata, templates, and conventions for generating:

  • Hub, Link, and Satellite tables for the integration layer
  • Materialized presentation layer tables
  • Supporting staging and persistent staging area structures
  • Classifications and conventions for Data Vault and Ensemble Logical Models (ELM)