Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Step 2: Set Database Properties for Metadata Tables

Excerpt Include
3.4.2 Set Database Properties
3.4.2 Set Database Properties
nopaneltrue


Note
titleImportant

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


Note
titleACT 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.



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

Oracle Database


indent
Level2

db.type=oracle


indent
Level2

db.username=i2b2metadata


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=i2b2metadata


indent
Level2

db.password=demouser


indent
Level2

db.driver=org.postgresql.Driver


indent
Level2

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


indent
Level2

db.project=demo



SQL Server Database


indent
Level2

db.type=sqlserver


indent
Level2

db.username=i2b2metadata


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



...