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 metadata tables.
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> |