Enterprise Data Ecosystem overview
Sources stay where they are, are virtualized, or are ingested into the governed lakehouse. One catalog, one security model and one set of data products serve reporting, research, AI and applications.
Sources connected
3 of 3
Legacy EMR, MariaDB EDW, lakehouse
Data products
5
4 certified, published to the catalog
Certified metrics
4
Defined once, reused in every model
Open research requests
2
Awaiting review or provisioning
Last pipeline run
2026-11-02 06:46
Bronze ingestion
EHR conversion
Mock load 2
Reconciled
Architecture in operation
Consumers
BI and semantic modelsCertified metrics, Direct Lake
Research workspacesHonest broker, OMOP
AI and data scienceGoverned retrieval
ApplicationsSQL, REST, FHIR
Data products
Longitudinal Oncology Recordv1.3.0 Certified
Revenue Cyclev2.1.0 Certified
Enterprise Patientv1.0.2 Certified
OMOP Research CDMv5.4 (build 2026.10) Endorsed
Lakehouse
Bronze15 tables, 854,095 rows
Silver10 tables, 727,032 rows
Gold10 tables, 934,049 rows
OMOP CDM9 tables, 650,326 rows
Virtualization
Federated query enginePushdown, caching, JDBC, ODBC, REST
Zero-copy accessMirrored and shortcut sources
Sources
Legacy EMR (SQL Server)Connected, 2,500 rows in 53 ms
MariaDB EDWConnected, 75,894 rows in 24 ms
Lakehouse (PostgreSQL)Connected, 2,500 rows in 36 ms
Recent governed activity
- Apply crosswalk fix Conversion
2026-11-02 23:39, Conversion lead
49 exceptions resolved; 17 crosswalk entries added - Provision I-34567
2026-11-02 23:39, J. Whitcomb
260 study identifiers generated (HMAC-SHA256, per-study key) - Provision I-45678
2026-09-03 09:30, J. Whitcomb
Study identifiers generated; crosswalk stored in linkage service