Page History
...
Step 2: Set the database properties for the crcdata tables
Anchor | ||||
---|---|---|---|---|
|
...
In the Directory Structure and Schema section of this installation guide we reviewed how the data installation files are structured within the i2b2_omop_data package. Each set of data tables (crcdata, metadata, and workdata) has its own data files for installing the appropriate data.
...
Within each of these directories
...
is a file called db.properties
...
that needs to be updated with your environment variables before we can begin installing the crcdata tables.
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 are familiar with the commands to open a file for editing. (commands are specific to the editor you use)
- You have already changed your working directory to the one that is appropriate for this installation.
Instructions:
1.
...
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
open db.properties |
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
db.properties |
...
Open the db.properties file.
2. Set the following properties for the DBMS at your site:
html-text | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Panel | |||||||||||
Panel |
| ||||||||||
Oracle Database db.type=oracle db.username= i2b2demodataYourCdmDatabaseUser db.password= demouserPasswordForYourCdmDatabaseUser db.server= LocationOfYourDatabaseLocationOfYourCdmDatabase:1521:xe db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@ LocationOfYourDatabaseLocationOfYourCdmDatabase:1521:xe db.project= omopOMOP PostgreSQL Database db.type=postgresql db.username= i2b2demodataYourCdmDatabaseUser db.password= demouserPasswordForYourCdmDatabaseUser db.driver=org.postgresql.Driver db.url=jdbc:postgresql:// LocationOfYourDatabase/i2b2?searchpath=i2b2demodataLocationOfYourCdmDatabase/YourCdmDatabase db.project= omopOMOP SQL Server Database db.type=sqlserver db.username= i2b2demodataYourCdmDatabaseUser db.password= demouserPasswordForYourCdmDatabaseUser db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver:// LocationOfYourDatabaseLocationOfYourCdmDatabase:1433;database= demoNameOfYourCdmDatabase db.project= omopOMOP |
3. Save the changes and close the file.
html-text |
---|
<div class="i2b2-panel">
|
...
<table class="i2b2-tip"> |
...
<colgroup> <col width="24"> |
...
<col> </colgroup> |
...
<tbody> <tr> <td> <img src="https://community.i2b2.org/wiki/download/attachments/14091764/icon_tip.png" width="16" height="16" align="absmiddle" alt="info" border="0"> |
...
</td> |
...
<td> <b>Tip</b> |
...
<br><br>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. |
...
</td> |
...
</tr> |
...
</tbody> |
...
</table> </div> |