input {
jdbc {
jdbc_driver_library => "sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_user => "userame"
dbc_connection_string=>
"jdbc:sqlserver://server\instance:1433;
database=database;integratedSecurity=true"
jdbc_password => "xxx"
statement => "SELECT * FROM table1"
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "cs_users"
#document_id => "%{Id}"
}
}