Hi All,
I am trying to connect SQL DB with Logstash. Getting exception please refer attachment
Below is the Logstash code
input {
jdbc {
jdbc_connection_string => "jdbc:sqlserver://server;databaseName=EmployeeDB,integratedSecurity=true;"
jdbc_user => "sa"
jdbc_password => "sa"
jdbc_driver_library => "C:/ELk/sqljdbc_4.2/enu/jre8/sqljdbc42.jar"
# The name of the driver class for SqlServer
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
# Query for testing purpos
statement => "SELECT * from details"
}
}
output {
elasticsearch{
hosts => ["http://127.0.0.1:9200"]
index => "indexsql"
}
stdout{ codec => rubydebug}
}