...

For detailed information refer to 2. Data Source Configuration, or, for an example of setting up data sources for OMOP: Configure Data Sources 

The datasource parameter should be set in the CRCBootStrapDS  section to point to the datasource of the CRC_DB_LOOKUP table. The to  CRCBootStrapDS for the CRCBootStrapDS pool name. 

Image Added

The datasource parameter value can be found in the CRC_DB_LOOKUP.C_DB_DATASOURCE (this is built at the time of datamart creation)

Image Removed

The datasource parameter should be set in the QueryToolDemoDS section  to point to the datasource of your Crcdata tables location (star-schema and QT tables)  

Example crc-ds.xml 

Image Removed

<datasource jta="false" jndi-name="java:/CRCBootStrapDS"
    pool-name="CRCBootStrapDS" enabled="true" use-ccm="false">
    <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url>
    <driver-class>oracle.jdbc.OracleDriver</driver-class>
    <driver>ojdbc6.jar</driver>
    <security>
        <user-name>i2b2hive</user-name>
        <password>demouser</password>
    </security>
    <validation>
        <validate-on-match>false</validate-on-match>
        <background-validation>false</background-validation>
    </validation>
    <statement>
        <share-prepared-statements>false</share-prepared-statements>
    </statement>
</datasource>
<datasource jta="false" jndi-name="java:/<CRC_DB_LOOKUP.C_DB_DATASOURCE value>"
    pool-name="<CRC_DB_LOOKUP.C_DB_DATASOURCE value>" enabled="true" use-ccm="false">
    <connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection-url>
    <driver-class>oracle.jdbc.OracleDriver</driver-class>
    <driver>ojdbc6.jar</driver>
    <security>
        <user-name>i2b2demodata</user-name>
        <password>demouser</password>
    </security>
    <validation>
        <validate-on-match>false</validate-on-match>
        <background-validation>false</background-validation>
    </validation>
    <statement>
        <share-prepared-statements>false</share-prepared-statements>
    </statement>
</datasource>

Step 5:

Load i2b2 tables into the database(s) used for the project as needed, making sure to update db properties file with the  db parameters (e.g., 3.4 Crcdata Tables, 3.7.4 Load Metadata Tables). For example, you might specify an existing database in the ontology db-lookup, but a new database in the CRC db lookup. In this case, you only need to create/load the tables in the CRC database.

...