Developers Getting Started With i2b2
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

Step 8: CRC properties: Configure data source lookup properties

During the hivedata installation one of the tables created was the CRC_DB_LOOKUP table. The CRC needs to communicate with this table and in order to do this we need to tell it where to find the Hivedata tables. During this step we will set the schema / database name for the hivedata.

Prerequisite

You need to know the location of your Hivedata tables. These are owned by the PM cell.


Steps to set the Data source lookup properties

These steps include example configurations for Oracle, PostgreSQL and SQL Server.


1. In the crc.properties file scroll to the section called Datasource Lookup properties.
2. Set the servertype to the type of database you are connecting to and set the schemaname to the name of the database / schema where your hivedata tables are located.


Datasource Lookup info

Oracle Configuration

queryprocessor.ds.lookup.datasource=CRCDataSourceLookup
queryprocessor.ds.lookup.servertype=ORACLE
queryprocessor.ds.lookup.schemaname=i2b2hive


PostgreSQL Configuration

queryprocessor.ds.lookup.datasource=CRCDataSourceLookup
queryprocessor.ds.lookup.servertype=PostgreSQL
queryprocessor.ds.lookup.schemaname=i2b2hive


SQL Server Configuration

queryprocessor.ds.lookup.datasource=CRCDataSourceLookup
queryprocessor.ds.lookup.servertype=SQLServer
queryprocessor.ds.lookup.schemaname=i2b2hive.dbo



3. Save your changes but do not close the file. You will be continuing to edit the file in the next few sections.