JDBC를 이용하여 logstash 연동 - MSSQL

1. MSSQL JDBC Driver download

 : https://docs.microsoft.com/ko-kr/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

2. logstash.conf

input {    jdbc {      jdbc_driver_library => "D:\logstash-6.3.0\logstash-6.3.0\bin\mssql-jdbc-6.4.0.jre8.jar"      jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"      jdbc_connection_string => "jdbc:sqlserver://Host|IP:1433;user=  ;password=  "      jdbc_user => " "      jdbc_password => " "      statement => " query "    }  }  filter {  }  output {    elasticsearch {      hosts => " localhost | IP:9200 "    }    stdout { codec => rubydebug }  }