Table of Contents
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.
