Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

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 4: Set Metadata schema name for the hivedata tables

During the hivedata installation one of the tables created was the ONT_DB_LOOKUP table. The Ontology needs to communicate with this table and in order to do this we need to tell it where to find the Hivedata tables. During this step we will set the database schema name for the hivedata.

Prerequisite

You need to know the location of your Hivedata tables. These are owned by the PM cell.


Steps to set the location of the ONT_DB_LOOKUP table

These steps include example configurations for Oracle, PostgreSQL and SQL Server.


indent
Level1

1. In the ontology.properties file scroll to the section called Bootstrap METADATA schema name.

indent
Level1

2. Set the metadataschema to the name of the database / schema where your hivedata tables are located.


Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#E5DFEC
titleBootstrap METADATA schema name
borderStylesolid

Oracle Configuration

indent
Level2

ontology.bootstrapdb.metadataschema=i2b2hive


PostgreSQL Configuration

indent
Level2

ontology.bootstrapdb.metadataschema=i2b2hive


SQL Server Configuration

indent
Level2

ontology.bootstrapdb.metadataschema=i2b2hive.dbo



indent
Level1

3. Save your changes and close the file.