input {
    jdbc {
        jdbc_connection_string => "jdbc:oracle:thin:@oraclehost:1522/ORASID"
        jdbc_user => "oracle_user"
		jdbc_password => "oracle_password"
        jdbc_driver_library => "/home/tsundara/elk/logstash-2.3.4/lib/jdbc_libs/ojdbc6.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
        statement => "SELECT * from ADDRESS where STATE_PROVINCE='NJ'"
    }
}

output {
    stdout { codec => json_lines }
}

# How to run it
export JAVA_HOME=/path/to/jdk8
./logstash-2.3.4/bin/logstash -f oracle_to_elastic.conf Logstash startup