This is an old revision of the document!
Multiple datasets configuration
A given institution implementing a CDM may have more than one datasets in CDM. A research may want to execute an OHDSI study on multiple CDM datasets and data and result schema should not refer to conflicting table names.
This wiki page documents a configuration that is most common at many implementing institution.
For example, a read-only schema with CDM data (e.g., person table, measurement table) may be in schema `dataA`. To allow (for example for Achilles) to write to result tables (e.g., achilles_results table), a corresponding schema (with write privileges) would be `dataA_results`.
The convention is that OHDSI software tools or studies do not try to manage various datasets (e.g., by columns in result tables (column for dataset in achilles_results table (for exmaple)). Instead, they rely on separation of results by simply separate database result schemas for each dataset.
ADDITION: So, if you have a CDM in schema 'dataA' and it is read-only, you can create a new schema 'dataA_results' that is writable, and when you execute Achilles, specify dataA as the cdm_database_schema and dataA_results as the results_database_schema.
Example setup for multiple datasets:
data schema,results schema --------------------------- dataA,dataA_results dataB,dataB_results