Overview of CRC Data Installation

The crcdata tables are part of the Data Repository (CRC) Cell. The following outlines the steps that will be taken during the crcdata installation.

Step 1:   Change your working directory

Step 2:   Set the database properties for the crcdata 

Step 3:   Create the crcdata tables, indexes and sequences

Step 4:   Create the stored procedures

Step 5:   Load sample data into the tables

Step 6:   Create the OMOP views

Step 1: Change Working Directory 

During the CRC Data Installation we will be working with the crcdata directory. Within this directory are the files we will be editing to define the database properties, create the crcdata tables and load the sample data provided with the i2b2 on OMOP data package.

To change your working directory to the crcdata directory enter the following command:

	Important
	The change directory command shown above is written for Windows. The command itself is the same for both Linux and Windows with the only exceptions being the slashes in the path name and Linux does not include the "drive". Linux Path: use a forward slash. Windows Path: use a backward slash.

Step 2:   Set the database properties for the crcdata tables 

 As stated earlier each i2b2 database schema has a corresponding directory that contains the data files for installing the data. Each of these directories has a file called db.properties and it needs to be updated with your environment variables.

Steps for setting database properties

Assumptions:

• You are logged into the command line application for your environment. (Linux: Terminal or Shell Windows: Command Prompt).
• You have already changed your working directory to the one that is appropriate for this installation.

Instructions:

1. At the command prompt type the following:

2. The db.properties file will open. Set the following properties for the DBMS at your site:

Important For the purpose of this document, when you set the database properties make sure you set the user to i2b2demodata and the project to demo.

Database Properties File

Oracle Database

db.type=oracle

db.username=i2b2demodata

db.password=demouser

db.server=LocationOfYourDatabase:1521:xe

db.driver=oracle.jdbc.driver.OracleDriver

db.url=jdbc:oracle:thin:@LocationOfYourDatabase:1521:xe

db.project=omop

PostgreSQL Database

db.type=postgresql

db.username=i2b2demodata

db.password=demouser

db.driver=org.postgresql.Driver

db.url=jdbc:postgresql://LocationOfYourDatabase/i2b2?searchpath=i2b2demodata

db.project=omop

SQL Server Database

 

db.type=sqlserver

 

db.username=i2b2demodata

 

db.password=demouser

 

db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

 

db.url=jdbc:sqlserver://LocationOfYourDatabase:1433;database=demo

 

db.project=omop

 

3. Save the changes and close the file.

Tip To save yourself steps, DO NOT close your Command Prompt window as you will be continuing to use it throughout the remainder of the installation.

 

 

Tip

To save yourself steps, DO NOT close your Command Prompt window as you will be continuing to use it throughout the remainder of the installation.

 

Step 3:   Create the crcdata tables, indexes and sequences 

Step 4:   Create the stored procedures 

Step 5:   Load sample data into the tables 

Step 6:   Create the OMOP views