Step 2: Set Database Properties for PM Tables

When setting the database properties make sure you set the user to i2b2pm. Projects are not assigned to Pmdata which is why the db.project property is not in the PM's db.properties file

As of 1.7.12, it is possible to load an ACT ontology project. When doing so, change the project to ACT when installing the PM data, to create the project entry and user entries in the database. More information can be found in the release notes.

Oracle Database

db.type=oracle

db.username=i2b2pm

db.password=demouser

db.server=LocationOfYourDatabase:1521:xe

db.driver=oracle.jdbc.driver.OracleDriver

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

PostgreSQL Database

db.type=postgresql

db.username=i2b2pm

db.password=demouser

db.driver=org.postgresql.Driver

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

SQL Server Database

db.type=sqlserver

db.username=i2b2pm

db.password=demouser

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

db.url=jdbc:sqlserver://LocationOfYourDatabase:1433;database=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.