---
title: 10.4.4.1.2 Data Source Lookup Properties
description: "# 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…"
url: "https://i2b2.org/docs/10-4-4-1-2-data-source-lookup-properties/"
updated: "2026-09-15"
category: "i2b2 Installation Guide / Chapter 4. Server Install Guide / B. Legacy Approach - Build Each Cell from Source / Chapter 10. Data Repository (CRC) Cell Install / 10.4 Configuration / 10.4.4 Configure the CRC Properties / 10.4.4.1 Required Environment Properties"
---

# 10.4.4.1.2 Data Source Lookup Properties

#

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.