3.7.2 Set Database Properties
Step 2: Set Database Properties for Metadata Tables
Important
When setting the database properties make sure you set the user to i2b2metadata and the project to demo.
ACT Ontology
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.
Tip
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.