Step 8: Configure the data sources for the IM Cell #

The IM cell needs to communicate with your i2b2 database and in order to do this it needs to know where the tables for the imdata and hivedata reside. Therefore the eighth and final step in the cell configuration process is to configure the data sources for the IM Cell. This information is configured in the im-ds.xml file.

Things to keep in mind when configuring your datasources: #

• The imdata and hivedata tables were created during the chapter on Data Installation.

• The IMBootStrapDS points to the data source for your WORK_DB_LOOKUP table which is a hivedata table.
  • The and need to match the database user you set up for your hivedata. In the i2b2 demo database this is i2b2hive and demouser.

• The IMDemoDS points to the data source for your imdata tables.
  • The and need to match the database user you set up for your imdata. In the i2b2 demo database this is i2b2imdata and demouser.

• The needs to have the following:
  • The correct JDBC information for your type of database.
  • The correct location of the database containing your imdata or hivedata tables. (These may or may not reside in the same location)

• Both the and need to accurately reflect the type of database you are connecting to.

Steps to configure data sources #

The following steps define how to configure your data sources for the IM Cell. These steps include example configurations for Oracle, PostreSQL and SQL Server.

1. The im-ds.xml file is located in the following directory:

YOUR_I2B2_SRC_DIR\edu.harvard.i2b2.im\etc\jboss

2. Open the im-ds.xml file to configure your data sources. (see examples shown below)

Oracle Database Configuration #

PostgreSQL Database Configuration #

SQL Server Database Configuration #

3. If your environment has multiple projects pointing to different data sources then copy the section for each project data source.

4. Update the jndi-name and pool-name to reflect the name of the second project .

Example:   A second project called Demo2 would have the following entry:

Second Data Source Configuration #

5. Save the changes and close the file.