RDC OMOP ETL Platform Reference
RDC OMOP ETL Services is a multi source ETL Platform that connects EHR data sources in order to populate the OMOP v5.3 databases. The OMOP v5.3 data model is a schema design used by many institutions as a standard for medical research data. The ETL consists of three primary services to facilitate ETL processing, the OMOP data instances, ETL configuration instances and NIFI processing services.
General Information
Server Name: OMOP Data Instances
| Name | Subscription | Resource group | Region | Environment | Deployment date |
|---|---|---|---|---|---|
| i2rdc3-dev-postgres01 | I2 - RDC 2.0 Azure POC - Dev | i2rdc3-dev-rg-main | Central US | Development | TBD |
| i2rdc3-qa-postgres01 | I2 - RDC 2.0 Azure POC - QA | i2rdc3-qa-rg-main | Central US | Quality Assurence | TBD |
| i2rdc3-prod-postgres01 | I2 - RDC 2.0 Azure POC - Prod | i2rdc3-prod-rg-main | Central US | Production | TBD |
Server Name: ETL configuration instances
| Name | Subscription | Resource group | Region | Environment | Deployment date |
|---|---|---|---|---|---|
| i2rdc3-prod-pg-flex-config.postgres.database.azure.com | I2 - RDC 2.0 Azure POC - Prod | i2rdc3-prod-rg-main | Central US | Production | TBD |
| i2rdc3-qa-pg-flex-config.postgres.database.azure.com | I2 - RDC 2.0 Azure POC - QA | i2rdc3-qa-rg-main | Central US | Quality Assurence | TBD |
| i2rdc3-dev-pg-flex-config.postgres.database.azure.com | I2 - RDC 2.0 Azure POC - Dev | i2rdc3-dev-rg-main | Central US | Development | TBD |
Server Name: NIFI processing services
| Name (portal Link) | Subscription | Resource group | Region | Environment | Deployment date |
|---|---|---|---|---|---|
| i2rdc3-prod-nifi01 | I2 - RDC 2.0 Azure POC - Prod | i2rdc3-prod-rg-main | Central US | Production | TBD |
| i2rdc3-prod-nifi02 | I2 - RDC 2.0 Azure POC - Prod | i2rdc3-prod-rg-main | Central US | Production | TBD |
| i2rdc3-prod-nifi03 | I2 - RDC 2.0 Azure POC - Prod | i2rdc3-prod-rg-main | Central US | Production | TBD |
| i2rdc3-qa-nifi01 | I2 - RDC 2.0 Azure POC - QA | i2rdc3-qa-rg-main | Central US | Quality Assurance | TBD |
| i2rdc3-qa-nifi02 | I2 - RDC 2.0 Azure POC - QA | i2rdc3-qa-rg-main | Central US | Quality Assurance | TBD |
| i2rdc3-qa-nifi03 | I2 - RDC 2.0 Azure POC - QA | i2rdc3-qa-rg-main | Central US | Quality Assurance | TBD |
| i2rdc3-dev-nifi01 | I2 - RDC 2.0 Azure POC - Dev | i2rdc3-dev-rg-main | Central US | Development | TBD |
| i2rdc3-dev-nifi02 | I2 - RDC 2.0 Azure POC - Dev | i2rdc3-dev-rg-main | Central US | Development | TBD |
| i2rdc3-dev-nifi03 | I2 - RDC 2.0 Azure POC - Dev | i2rdc3-dev-rg-main | Central US | Development | TBD |