Step 2: Set the database properties for the workdata tables
| Anchor |
|---|
| omop_workdata_step2 |
|---|
| omop_workdata_step2 |
|---|
|
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 workdata 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. Open the db.properties file.
2. Set the following properties for the DBMS at your site:
| Panel |
|---|
| borderColor | #ccc |
|---|
| bgColor | #ffffff |
|---|
| titleBGColor | #E5DFEC |
|---|
| borderStyle | solid |
|---|
| title | Database Properties File |
|---|
|
Oracle Database db.type=oracle db.username=YourCdmDatabaseUser db.password=PasswordForYourCdmDatabaseUser db.server=LocationOfYourCdmDatabase:1521:xe db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@LocationOfYourCdmDatabase:1521:xe db.project=OMOP
PostgreSQL Database db.type=postgresql db.username=YourCdmDatabaseUser db.password=PasswordForYourCdmDatabaseUser db.driver=org.postgresql.Driver db.url=jdbc:postgresql://LocationOfYourCdmDatabase/YourCdmDatabase db.project=OMOP
SQL Server Database db.type=sqlserver db.username=YourCdmDatabaseUser db.password=PasswordForYourCdmDatabaseUser db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver://LocationOfYourCdmDatabase:1433;database=NameOfYourCdmDatabase db.project=OMOP |
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> |
| Section |
|---|
Step 2: Set the database properties for the workdata tables | Anchor |
|---|
| omop_workdata_step2 |
|---|
| omop_workdata_step2 |
|---|
|
| 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 propertiesAssumptions:- 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: | Panel |
|---|
| borderColor | #ccc |
|---|
| bgColor | #ffffff |
|---|
| titleBGColor | #DDD9C3 |
|---|
| borderStyle | solid |
|---|
| title | Linux Command |
|---|
| open db.properties |
| Panel |
|---|
| borderColor | #ccc |
|---|
| bgColor | #ffffff |
|---|
| titleBGColor | #DDD9C3 |
|---|
| borderStyle | solid |
|---|
| title | Windows Command |
|---|
| db.properties |
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>Important</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> |
| Panel |
|---|
| borderColor | #ccc |
|---|
| bgColor | #ffffff |
|---|
| titleBGColor | #E5DFEC |
|---|
| borderStyle | solid |
|---|
| title | 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. | 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>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> |
|
