Supporting documentation for Joe Salmon's Business & Performance Business Partner demonstration site. Demonstration material only.

Synthetic Demo Rivers Health material only — not Dorset HealthCare/RDY public data.

ADF-style pipeline overview (demonstration specification)

Not deployed. Fictional linked services and datasets for Demo Rivers Health warehouse demo.

Orchestration

flowchart LR
    pl1[pl_ingest_source_csv] --> pl2[pl_stage_and_conform]
    pl2 --> pl3[pl_load_dwh_facts]
    pl3 --> pl4[pl_refresh_marts]

Pipeline	Schedule	Depends on
`pl_ingest_source_csv`	Daily 02:30 UTC	Source CSV drop
`pl_stage_and_conform`	Daily 03:00 UTC	Ingest complete
`pl_load_dwh_facts`	Daily 03:30 UTC	Staging DQ pass
`pl_refresh_marts`	Daily 04:00 UTC	Facts loaded

Linked services (fictional)

ls_demo_blob — Azure Blob demorivers-src / source-data/
ls_demo_sql — Azure SQL DemoRiversDWH (demo server placeholder)
ls_demo_keyvault — Key Vault placeholder (no real secrets)

DQ gates between activities

Row count vs source_manifest.csv tolerance ±0%
Referential integrity contact→case (warn not fail)
date_boundary_mismatch_flag summary logged
Extract change log join for reporting month

See JSON specs in this folder and pipeline_parameters.md.