Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Old Version 2

changes.mady.by.user Jeffrey Klann

Saved on

compared with

New Version 3

changes.mady.by.user Jeffrey Klann

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 Database Properties for Crcdata Tables

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 properties


Assumptions:

  • You are logged into the command line application for your environment. (Linux: Terminal or Shell and Windows: Command Prompt)
  • You have already changed your working directory to the one that is appropriate for this installation.


indent
Level1

1. At the command prompt type the following:


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

      open db.properties


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

      db.properties



indent
Level1

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


Note
titleImportant

When setting the database properties make sure you set the user to i2b2demodata and the project to demo.



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

Oracle Database

indent
Level2

db.type=oracle

indent
Level2

db.username=i2b2demodata

indent
Level2

db.password=demouser

indent
Level2

db.server=LocationOfYourDatabase:1521:xe

indent
Level2

db.driver=oracle.jdbc.driver.OracleDriver

indent
Level2

db.url=jdbc:oracle:thin:@LocationOfYourDatabase:1521:xe

indent
Level2

db.project=demo


PostgreSQL Database

indent
Level2

db.type=postgresql

indent
Level2

db.username=i2b2demodata

indent
Level2

db.password=demouser

indent
Level2

db.driver=org.postgresql.Driver

indent
Level2

db.url=jdbc:postgresql://LocationOfYourDatabase/i2b2?searchpath=i2b2demodata

indent
Level2

db.project=demo


SQL Server Database

indent
Level2

db.type=sqlserver

indent
Level2

db.username=i2b2demodata

indent
Level2

db.password=demouser

indent
Level2

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

indent
Level2

db.url=jdbc:sqlserver://LocationOfYourDatabase:1433;database=demo

indent
Level2

db.project=demo




indent
Level1

3. Save the changes and close the file.


Tip
titleTip

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.