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.
| indent |
|---|
|
1. In the crc.properties file scroll to the section called Datasource Lookup properties. |
| indent |
|---|
|
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. |
| Panel |
|---|
| borderColor | #ccc |
|---|
| bgColor | #ffffff |
|---|
| titleBGColor | #E5DFEC |
|---|
| title | Datasource Lookup info |
|---|
| borderStyle | solid |
|---|
|
Oracle Configuration | indent |
|---|
| queryprocessor.ds.lookup.datasource=CRCDataSourceLookup |
| indent |
|---|
| queryprocessor.ds.lookup.servertype=ORACLE |
| indent |
|---|
| queryprocessor.ds.lookup.schemaname=i2b2hive |
PostgreSQL Configuration
| indent |
|---|
| queryprocessor.ds.lookup.datasource=CRCDataSourceLookup |
| indent |
|---|
| queryprocessor.ds.lookup.servertype=PostgreSQL |
| indent |
|---|
| queryprocessor.ds.lookup.schemaname=i2b2hive |
SQL Server Configuration
| indent |
|---|
| queryprocessor.ds.lookup.datasource=CRCDataSourceLookup |
| indent |
|---|
| queryprocessor.ds.lookup.servertype=SQLServer |
| indent |
|---|
| queryprocessor.ds.lookup.schemaname=i2b2hive.dbo |
|
| indent |
|---|
|
3. Save your changes but do not close the file. You will be continuing to edit the file in the next few sections. |
