My bo_firmas_electronicas.conf:
input {
jdbc {
jdbc_driver_library => "D:\Elastic\logstash-8.6.0\lib\ojdbc8.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@//10.100.152.36:1521/SID"
jdbc_user => "*****"
jdbc_password => "******"
jdbc_validate_connection => true
statement_filepath => "D:\Elastic\logstash-8.6.0\config\conf.d\bigStatements\bo_firmas_electronicas_v2.sql"
#tracking_column => "dhora_solicitud"
#use_column_value => true
#tracking_column_type => "timestamp"
#last_run_metadata_path => "D:\Elastic\logstash-8.6.0\config\conf.d\tracking_column\.last_value_bo_firmas_electronicas"
}
}
output {
elasticsearch {
hosts => ["http://localhost:9200"]
index => "bo_firmas_electronicas-104666"
user => "elastic"
password => "******"
}
}