Integration
Data Sources & Refresh
Every measure traces back to a governed source. Refresh cadence ranges from 15-minute near real-time pulls to nightly state file loads.
Source systems
- • Case management (SQL Server)
- • Electronic Health Record
- • State systems (Crossroads, NC EDSS)
- • Spreadsheets on SharePoint/OneDrive
Ingestion
- • Secure REST APIs
- • OData feeds
- • Azure Data Factory pipelines
- • SFTP landing → ADF
Curated warehouse
- • Azure SQL / SQL Server
- • Conformed dimensions
- • Measure semantic model
- • Row-level security by role
Delivery
- • Power BI datasets & reports
- • Embedded scorecard app
- • Scheduled exports
- • Entra ID SSO
| Source | System | Method | Cadence | Last run | Rows | PHI | Status |
|---|---|---|---|---|---|---|---|
Case Management System Behavioral Health, Harm Reduction, Communicable Disease, Clinical Services | On-prem SQL Server | Secure API | Every 15 minutes | 4 min ago | 184,920 | PHI | healthy |
Electronic Health Record Clinical Services, Behavioral Health, Communicable Disease | EHR vendor cloud | OData | Hourly | 22 min ago | 412,308 | PHI | healthy |
WIC Crossroads Extract WIC | State system | SFTP → ADF | Nightly 02:00 | 16 hr ago | 96,140 | PHI | healthy |
NC EDSS Surveillance Communicable Disease | State system | Azure Data Factory | Every 4 hours | 3 hr 40 min ago | 58,210 | PHI | delayed |
Environmental Inspections Environmental Health | On-prem SQL Server | Secure API | Every 30 minutes | 12 min ago | 74,180 | — | healthy |
CHIP & Survey Workbooks CHA / CHIP, Preparedness | SharePoint / OneDrive | SharePoint sync | Every 6 hours | 1 hr ago | 8,420 | — | healthy |
Finance & Cost Allocation All programs | ERP extract | Azure Data Factory | Nightly 01:00 | 17 hr ago | 31,280 | — | healthy |
Legacy Spreadsheet Uploads Preparedness | OneDrive folder | SharePoint sync | On upload | 2 days ago | 2,140 | — | failed |
Near real-time (15 min): operational measures such as crisis encounters, inspections, and outreach contacts.
Hourly: EHR-derived clinical measures where the source system publishes incremental change feeds.
Nightly: state extracts, finance allocations, and any measure with a monthly reporting cycle.
Failed or delayed pipelines raise an operations alert and the affected tiles display a stale-data banner rather than silently showing old numbers.
In transit & at rest: TLS 1.2+, private endpoints, and customer-managed keys on all PHI-bearing stores.
Minimum necessary: pipelines pull only the fields required by an approved measure definition.
Identity: managed identities for service-to-service auth; Entra ID groups drive row-level security.
BAA: processing governed by the Buncombe County Business Associate Agreement, with audit logging retained per policy.