How data flows from CDM to Oracle Healthcare Translational Research-Notebooks

Pre-built Oracle Healthcare Translational Research notebooks retrieve clinical data from Oracle Healthcare Foundation via two mechanisms. The data for PgX graphs is sourced from the API schema via a JDBC connection. Only de-identified (obfuscated) attribute values are used in these graphs. A separate mechanism is used to obtain records with patient details. It utilizes Python's cx-Oracle module with a configured connection to the API schema. This connection passes through a data access layer that enables authorized notebook users to retrieve original (unobfuscated) patient records.