Hi @balumurari1 ,
input {
jdbc {
jdbc_connection_string => "jdbc:sqlserver://XXXXX;databaseName=XXXX;integratedSecurity=false;"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_user => "XXXX"
jdbc_password => "XXX"
jdbc_driver_library => "/path/jre8/sqljdbc42.jar"
statement => "SELECT id,name FROM sampletable where id> :sql_last_value "
tracking_column => "id"
use_column_value => true
last_run_metadata_path => "/path/.logstash_jdbc_last_run"
schedule => "*/5 * * * * *"
}
}
output {
elasticsearch {
hosts => "http://localhost:9200"
index => "sampleindex"
}
stdout{ }
}