Step 2:   Set the database properties for the workdata tables 

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:

Instructions:

1. Open the db.properties file.

2. Set the following properties for the DBMS at your site:

 

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.

 

<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>

Step 2:   Set the database properties for the workdata 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:

      open db.properties

      db.properties

 

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

 

<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>

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.

<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>