OMOP
Space shortcuts
Space Tools
OMOP OMOP

Versions Compared

Old Version 5

changes.mady.by.user Janice Donahoe

Saved on

compared with

New Version Current

changes.mady.by.user Janice Donahoe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Step 2:   Set the database properties for the metadata tables 
Anchor
omop_metadata_step2
omop_metadata_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 metadata 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
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleLinux Command

      open db.properties

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

      db.properties

 

Open the db.properties file.

2

...

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

 

...

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#E5DFEC
borderStylesolid
titleDatabase Properties File

Oracle Database

db.type=oracle

db.username=

i2b2demodata

YourCdmDatabaseUser

db.password=

demouser

PasswordForYourCdmDatabaseUser

db.server=

LocationOfYourDatabase

LocationOfYourCdmDatabase:1521:xe

db.driver=oracle.jdbc.driver.OracleDriver

db.url=jdbc:oracle:thin:@

LocationOfYourDatabase

LocationOfYourCdmDatabase:1521:xe

db.project=

omop

OMOP


PostgreSQL Database

db.type=postgresql

db.username=

i2b2demodata

YourCdmDatabaseUser

db.password=

demouser

PasswordForYourCdmDatabaseUser

db.driver=org.postgresql.Driver

db.url=jdbc:postgresql://

LocationOfYourDatabase/i2b2?searchpath=i2b2demodata

LocationOfYourCdmDatabase/YourCdmDatabase

db.project=

omop

OMOP


SQL Server Database

db.type=sqlserver

 

db.username=

i2b2demodata

YourCdmDatabaseUser

 

db.password=

demouser

PasswordForYourCdmDatabaseUser

 

db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

 

db.url=jdbc:sqlserver://

LocationOfYourDatabase

LocationOfYourCdmDatabase:1433;database=

demo

NameOfYourCdmDatabase

 

db.project=

omop

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>

...

 

...




    
    







    

    




    
    

    
    
    




                    


                    

                

                
            


                        
        


    



OMOP
OMOP