Could not connect to SQL DB using JDBC in Logstash

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}

}

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.