Step 2: Set Database Properties for Metadata Tables

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

As of 1.7.12, it is possible to load the ACT ontology instead of the demo ontology. In this case, change the project to ACT. More information can be found in the release notes.

Oracle Database

db.type=oracle

db.username=i2b2metadata

db.password=demouser

db.server=LocationOfYourDatabase:1521:xe

db.driver=oracle.jdbc.driver.OracleDriver

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

db.project=demo

PostgreSQL Database

db.type=postgresql

db.username=i2b2metadata

db.password=demouser

db.driver=org.postgresql.Driver

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

db.project=demo

SQL Server Database

db.type=sqlserver

db.username=i2b2metadata

db.password=demouser

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

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

db.project=demo

3. Save the changes and close the file.

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.