Set up a project as documented here:
Update DB_Lookup tables to define the Wildfly XML datasource name for the project. Refer to 6.4.3 Cell DB-Lookup: for details.
Add new db_lookup entries for each of the core cells, to define how the project will connect to the db.
Note: for ONT_DB_LOOKUP and workplace_db_look up, c_project path does not have a beginning backslash
Update DATASOURCE XML files IN WILDFLY IF NEEDED
The data source is defined in the ds-xml file with parameters to connect to the hive and data tables. The DB_Lookup.C_DB_Data source value should be the same for the poolname as well as the jndi-name connection values
The CRC cell uses these configuration values to communicate with your i2b2db instance
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 value can be found in the CRC_DB_LOOKUP.C_DB_DATASOURCE (this is built at the time of datamart creation) to point to the datasource of your Crcdata tables location (star-schema and QT tables)
Note: The pool-name parameter and as well the jndi-name value for the Bootstrap connection section should be set to CRCBootStrapDS .
Example crc-ds.xml
<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>
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.
Finally add project users. Make sure to add AGG_SERVICE_ACCOUNT
https://community.i2b2.org/wiki/display/ServerSideDesign/Project+Setup