Page History
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 this stage of the
...
installation.
Step 1: Change your working directory
Step 2:
...
Set the database properties for the crcdata
Step 3:
...
...
Data Repository (CRC) tables, indexes and sequences
Step 4:
...
Step 5:
...
Load sample data into the tables
Step 6:
...
...
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.
...
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
...
Excerpt | ||
---|---|---|
|
...
indent | ||
---|---|---|
| ||
Windows Command: CD C:\opt\data\i2b2_omop_data\oracle\CRCdata |
indent | ||
---|---|---|
| ||
Linux Command: CD /opt/data/i2b2_omop_data/oracle/CRCdata |
...
Excerpt | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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:
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:
|
html-text |
---|
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/14091764/icon_important.png" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>For the purpose of this document, when you set the database properties make sure you set the user to <b>i2b2demodata</b> and the project to <b>demo</b>
</td>
</tr>
</tbody>
</table>
</div> |
...
borderColor | #ccc |
---|---|
bgColor | #ffffff |
titleBGColor | #E5DFEC |
borderStyle | solid |
title | Database Properties File |
...
indent | ||
---|---|---|
| ||
db.type=oracle |
indent | ||
---|---|---|
| ||
db.username=i2b2demodata |
indent | ||
---|---|---|
| ||
db.password=demouser |
indent | ||
---|---|---|
| ||
db.server=LocationOfYourDatabase:1521:xe |
indent | ||
---|---|---|
| ||
db.driver=oracle.jdbc.driver.OracleDriver |
indent | ||
---|---|---|
| ||
db.url=jdbc:oracle:thin:@LocationOfYourDatabase:1521:xe |
indent | ||
---|---|---|
| ||
db.project=demo |
...
indent | ||
---|---|---|
| ||
db.type=postgresql |
indent | ||
---|---|---|
| ||
db.username=i2b2demodata |
indent | ||
---|---|---|
| ||
db.password=demouser |
indent | ||
---|---|---|
| ||
db.driver=org.postgresql.Driver |
indent | ||
---|---|---|
| ||
db.url=jdbc:postgresql://LocationOfYourDatabase/i2b2?searchpath=i2b2demodata |
indent | ||
---|---|---|
| ||
db.project=demo |
...
indent | ||
---|---|---|
| ||
db.type=sqlserver |
indent | ||
---|---|---|
| ||
db.username=i2b2demodata |
indent | ||
---|---|---|
| ||
db.password=demouser |
indent | ||
---|---|---|
| ||
db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver |
indent | ||
---|---|---|
| ||
db.url=jdbc:sqlserver://LocationOfYourDatabase:1433;database=demo |
indent | ||
---|---|---|
| ||
db.project=demo |
...
indent | ||
---|---|---|
| ||
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. |
...
...
...
...