documentation:software:webapi:multiple_datasets_configuration
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:software:webapi:multiple_datasets_configuration [2017/06/19 18:35] anthonysena |
documentation:software:webapi:multiple_datasets_configuration [2019/04/19 16:20] (current) anthonysena |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| - | ====Multiple datasets configuration==== | + | ===== IMPORTANT NOTE ===== |
| + | |||
| + | All WebAPI documentation has moved to [[https://github.com/OHDSI/WebAPI/wiki|GitHub]]. Please disregard the content below as it is legacy and kept for posterity. | ||
| + | |||
| + | ====Multiple datasets configuration (LEGACY) ==== | ||
| ---- | ---- | ||
| Line 28: | Line 32: | ||
| In the single CDM setup, it's common to use the tables created in the WebAPI schema as the results schema for the CDM. Once additional CDMs are introduced, it's necessary to deploy specific tables to each CDM result schema hosted on each CDM database. The following tables can be exported from the WebAPI schema and deployed into the CDM result schema: | In the single CDM setup, it's common to use the tables created in the WebAPI schema as the results schema for the CDM. Once additional CDMs are introduced, it's necessary to deploy specific tables to each CDM result schema hosted on each CDM database. The following tables can be exported from the WebAPI schema and deployed into the CDM result schema: | ||
| - | | cohort_inclusion | heracles_heel_results | | + | | cohort | heracles_analysis | |
| - | | cohort_inclusion_result | heracles_results | | + | | COHORT_FEATURES |feas_study_result | |
| - | | cohort_inclusion_stats | heracles_results_dist | | + | | COHORT_FEATURES_DIST |feas_study_index_stats | |
| - | | feas_study_inclusion_stats | ir_analysis_dist| | + | | COHORT_FEATURES_REF |heracles_heel_results | |
| - | | feas_study_index_stats | ir_analysis_strata_stats | | + | | COHORT_FEATURES_ANALYSIS_REF | heracles_results | |
| - | | feas_study_result | ir_analysis_result | | + | | cohort_inclusion |heracles_results_dist | |
| - | | heracles_analysis | ir_strata | | + | | cohort_inclusion_result |ir_analysis_dist | |
| + | | cohort_inclusion_stats |ir_analysis_strata_stats | | ||
| + | | cohort_summary_stats |ir_analysis_result | | ||
| + | | feas_study_inclusion_stats |ir_strata | | ||
| To find this DDL, explore your local WebAPI database schema, and use the tool (example, pgAdmin for Postgresql) to export the DDL and execute on each CDM. | To find this DDL, explore your local WebAPI database schema, and use the tool (example, pgAdmin for Postgresql) to export the DDL and execute on each CDM. | ||
documentation/software/webapi/multiple_datasets_configuration.1497897311.txt.gz · Last modified: 2017/06/19 18:35 by anthonysena
Page Tools
