OMOP
Space shortcuts
Space Tools

Versions Compared

Key

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

 

Configure Data Sources

Update data lookup tablesUpdate

CRC Properties

file

Step 3: Configure the build properties

The third step in the i2b2 on OMOP configuration process is to edit the build.properties file for edu.harvard.i2b2.pm. During this step you need to set the jboss.home and axis2.war.name properties.

 

Excerpt

Steps to update build.properties

 

indent
Level1

1. At the command prompt type the following:

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleLinux Command
indent
Level2

open build.properties

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleWindows Command
indent
Level2

build.properties

indent
Level1

2. The build.properties file will open. Set the following properties to reflect your environment:

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#E5DFEC
borderStylesolid
titleBuild Properties File
indent
Level2

queryprocessormultifacttable=true

indent
Level1

3. Save the changes and close the file.

Update crc.properties

CRC Properties Configuration

The crc.properties file contains a number of properties that define how the CRC cell will behave during certain operations. For the i2b2 on OMOP project there is only one property in this file that needs to be modified. 

 

Property Name

Configuration

In order for the CRC to know there are multiple fact tables the queryprocessor.multifacttable property in the crc.properties file needs to be updated. By default this property is set to false, however for the i2b2 on OMOP project this needs to be set to true.

Property: queryprocessor.multifacttable

ValueBehavior
falseThe CRC will continue to work as it does in the classic i2b2. Only one fact table (observation_fact) will be queried
trueThe CRC will query multiple fact tables as defined in the OMOP CDM version 5

 

Update crc.properties file

Assumptions:

  • You are logged into the command line application for your environment. (Linux: Terminal or Shell and Windows: Command Prompt)
  • You have already changed your working directory to the one that is appropriate for this installation.

 

indent
Level1

1. At the command prompt type the following:

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleLinux Command

indent
Level2

open YOUR_I2B2_SRC_DIR/edu.harvard.i2b2.crc/etc/spring/crc.properties

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleWindows Command

indent
Level2

YOUR_I2B2_SRC_DIR\i2b2\edu.harvard.i2b2.crc\etc\spring\crc.properties

EXAMPLES:

indent
Level2

Linux Command:  open /opt/i2b2/edu.harvard.i2b2.crc/etc/spring/crc.properties

indent
Level2

Windows Command:  C:\opt\i2b2\edu.harvard.i2b2.crc\etc\spring\crc.properties

indent
Level1

2. The crc.properties file will open.

indent
Level1

3. Scroll Open the crc.properties file and scroll to the section called Derived/Multi fact table parameter.

indent
Level1

42. Edit the queryprocessor.multifacttable property to turn on the i2b2 on OMOP featuretell the CRC to query multiple fact tables.

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#E5DFEC
borderStylesolid
titleProject Management Cell

indent
Level2

# Derived/Multi fact table parameter

indent
Level2

queryprocessor.multifacttable=true

indent
Level1

4. Save your changes and close the file if you do not need to edit any more properties.