Differences

This shows you the differences between two versions of the page.

--- documentation:software:webapi:multiple_datasets_configuration [2016/08/23 19:52] – created jhardin
+++ documentation:software:webapi:multiple_datasets_configuration [2019/04/19 16:20] (current) – anthonysena
@@ Line 1: / Line 1: @@
 ~~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 25: / Line 29: @@
     dataB,dataB_results
+=== Result Schema Tables ===
+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 | heracles_analysis |
+| COHORT_FEATURES |feas_study_result  |
+| COHORT_FEATURES_DIST |feas_study_index_stats  |
+| COHORT_FEATURES_REF |heracles_heel_results  |
+| COHORT_FEATURES_ANALYSIS_REF | heracles_results  |
+| cohort_inclusion |heracles_results_dist  |
+| 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.