logstash从oracle抽数据到kafka
input {
jdbc {
jdbc_driver_library => “ojdbc6-11.2.0.3.0.jar 插件的”
jdbc_driver_class => “Java::oracle.jdbc.OracleDriver”
jdbc_connection_string => “jdbc:oracle:thin:@//url/库名”
jdbc_user => “用户名”
jdbc_password => “密码”
schedule => “* * * * *”
jdbc_default_timezone => “Etc/UTC”
statement => “select id,birthday,id_type,id_no,last_update_time from sehr_xman “//要抽取的数据
last_run_metadata_path => “/home/elk/logstash-5.4.0/config/meta/ssp_service_journal”
use_column_value => true
tracking_column => “last_update_time”
tracking_column_type => “timestamp”
type => “zoe_agegroup”
add_field => {“device_id” => “zoe-005”}
}
}
output {
kafka{ //抽取到kafka上
topic_id => “zoe_por_agegroup”