This is a sample application to demonstrates using Drools rules against the OHDSI data structure.

A few simple drools rules are contained within the src/main/resources/rules/risk.drl directory.

SETUP

You must change the following in the DroolsTest.java file

private static final String USERNAME = "<username>";    
private static final String PASS = "<password>";
private static final String IP = "<IP>";

BUILD

There is a maven pom.xml file used to build the application

mvn install

NOTE: If you are connecting to an Oracle OHDSI CDM database then you need to acquire the Oracle ojdbc driver and install it in your local repository like this BEFORE running the 'install' target:

mvn install:install-file -Dfile=<Path to ojdbc jar> -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=<version> -Dpackaging=jar

Example:

mvn install:install-file -Dfile=/tmp/ojdbc6/11.2.0.3/ojdbc6-11.2.0.3.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.3 -Dpackaging=jar

RUN

java -jar target/droolstest-1.0.jar

The results can be viewed in the OHDSI.RISK_ANALYSIS table