Exadata Migration - CDRN
- Daniel Popham
This page will be used to track the different projects that need to be moved from the Oracle Exadata environment to another environment.
| Exadata Schema Name | Project Name | Process Type | Process Name | Process Location | Owner | Notes |
|---|---|---|---|---|---|---|
ACT_I2B2_DATA | ACT | N/A | N/A | N/A | Daniel Popham | Decommissioned project as of May 2023. However, there is data in the following schemas that should be archived somewhere before Exadata is decommissioned. |
ACT_I2B2_HIVE | ACT | N/A | N/A | N/A | Daniel Popham | |
ACT_I2B2_IMDATA | ACT | N/A | N/A | N/A | Daniel Popham | |
ACT_I2B2_METADATA | ACT | N/A | N/A | N/A | Daniel Popham | |
ACT_I2B2_PM | ACT | N/A | N/A | N/A | Daniel Popham | |
ACT_I2B2_SHRINE_ONT | ACT | N/A | N/A | N/A | Daniel Popham | |
ACT_I2B2_WORKDATA | ACT | N/A | N/A | N/A | Daniel Popham | |
| ACT_TEST_DATA | ACT | N/A | N/A | N/A | Daniel Popham | Decommissioned project as of May 2023. All of these schemas can be removed. |
| ACT_TEST_HIVE | ACT | N/A | N/A | N/A | Daniel Popham | |
| ACT_TEST_IMDATA | ACT | N/A | N/A | N/A | Daniel Popham | |
| ACT_TEST_METADATA | ACT | N/A | N/A | N/A | Daniel Popham | |
| ACT_TEST_PM | ACT | N/A | N/A | N/A | Daniel Popham | |
| ACT_TEST_SHRINE_ONT | ACT | N/A | N/A | N/A | Daniel Popham | |
| ACT_TEST_WORKDATA | ACT | N/A | N/A | N/A | Daniel Popham | |
| CODI | CODI | Airflow DAG | DEV: plt-nosql01.dhe.duke.edu PRD: plp-nosql01.dhe.duke.edu | Daniel Popham | Contains data used for the CODI project, supported by the PCORNet CDM data. Project has been decommissioned and the associated DAG has been disabled. | |
HSC_I2B2_DATA | Carolinas Collaborative (CC) | N/A | N/A | N/A | Daniel Popham | Decommissioned project some time before 2020. However, required to keep data until end of year 2025 for archival/historical purposes. Data in the following schemas should be archived somewhere before Exadata is decommissioned |
| HSC_I2B2_HIVE | Carolinas Collaborative (CC) | N/A | N/A | N/A | Daniel Popham | |
| HSC_I2B2_IMDATA | Carolinas Collaborative (CC) | N/A | N/A | N/A | Daniel Popham | |
| HSC_I2B2_METADATA | Carolinas Collaborative (CC) | N/A | N/A | N/A | Daniel Popham | |
| HSC_I2B2_PM | Carolinas Collaborative (CC) | N/A | N/A | N/A | Daniel Popham | |
| HSC_I2B2_SHRINE_ONT | Carolinas Collaborative (CC) | N/A | N/A | N/A | Daniel Popham | |
| HSC_I2B2_WORKDATA | Carolinas Collaborative (CC) | N/A | N/A | N/A | Daniel Popham | |
HSC_PCOR | N3C | Airflow DAG | N3C Only: vwp-pmndmc.dhe.duke.edu | Daniel Popham | Project that runs monthly to generate data for N3C project from monthly refresh. | |
| PCORNet/STAR | Daniel Popham | Project that contains the PCORNet CDM data that is refreshed both quarterly and monthly. | ||||
| RECOVER | Daniel Popham | Project that runs quarterly to generate data for RECOVER project based on available PCORNet refresh data . | ||||
| Bayer | Python Script | BayerExtract.py | Daniel Popham | Data extract from external database into HSC_PCOR schema. Script is located on shared drive, \\duhs-clin-nc1\duhs_pmn_dmc_fs\Bayer\. Mapped to H: on vwp-pmndmc.dhe.duke.edu. | ||
| RXNORM | PCORNet/STAR | Unix Shell Script | RxNormLoad.sh | Daniel Popham | Process related to the PCORNet/STAR project that refreshes RxNorm data on a quarterly basis, before the STAR quarterly refresh. Manually run. | |
| RXNORM_2017 | PCORNet/STAR | Windows Batch File | N3C_Main.bat | vwp-pmndmc.dhe.duke.edu | Daniel Popham | Actually used for N3C project. These tables should be moved somewhere else that makes more sense. |