Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
This is an old revision of the document!
The OHDSI tools interact directly with the data in the OMOP Common Data Model (CDM). As such, they need to connect with the database server, and perform advanced analytics, both on the server and the client. The OHDSI tools currently support a wide range of DataBase Management Systems (DBMS), to varying degrees. Many have expressed interest in expanding the list of DBMSs even further.
For OHDSI R packages:
For ATLAS:
? (Note: not sure what is needed, and how far this needs to be split up. WebAPI? Specific services in WebAPI?)
The CDM DDL is automatically generated from a master DDL through SqlRender translation.
Who supports which DBMS for which OHDSI tool? (Names are Github handles)
SQL Server | Oracle | PostgreSQL | PDW | RedShift | Impala | BigQuery | Netezza | Sqlite | |
---|---|---|---|---|---|---|---|---|---|
SqlRender | schuemie | schuemie | schuemie | schuemie | schuemie | schuemie | |||
DatabaseConnector | schuemie | schuemie | schuemie | schuemie | schuemie | schuemie | |||
CI server | leeevans | leeevans | leeevans | ||||||
ACHILLES | |||||||||
Methods Library | schuemie | schuemie | schuemie | schuemie | schuemie | schuemie | |||
ATLAS |