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.
You need to know the location of your Hivedata tables. These are owned by the PM cell.
These steps include example configurations for Oracle, PostgreSQL and SQL Server.
indent |
---|
|
1. In the ontology.properties file scroll to the section called Bootstrap METADATA schema name. |
indent |
---|
|
2. Set the metadataschema to the name of the database / schema where your hivedata tables are located. |
Panel |
---|
borderColor | #ccc |
---|
bgColor | #ffffff |
---|
titleBGColor | #E5DFEC |
---|
title | Bootstrap METADATA schema name |
---|
borderStyle | solid |
---|
|
Oracle Configuration indent |
---|
| ontology.bootstrapdb.metadataschema=i2b2hive |
PostgreSQL Configuration
indent |
---|
| ontology.bootstrapdb.metadataschema=i2b2hive |
SQL Server Configuration
indent |
---|
| ontology.bootstrapdb.metadataschema=i2b2hive.dbo |
|
indent |
---|
|
3. Save your changes and close the file. |