OMOP
Space shortcuts
Space Tools

Versions Compared

Old Version 4

changes.mady.by.user Janice Donahoe

Saved on

compared with

New Version 5

changes.mady.by.user Janice Donahoe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
As stated earlier each i2b2 database schema has a corresponding directory that contains the 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. Each Within each of these directories has is a file called db.properties and it 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.

At the command prompt type the following:

 

Section

Step 2:   Set the database properties for the crcdata tables 
Anchor
omop_crcdata_step2
omop_crcdata_step2

 

Excerpt
Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleLinux Command

      open db.properties

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleWindows Command

      db.properties

 

2. The db.properties file will open.

Open the db.properties file.

2. 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
borderStylesolid
titleDatabase 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>