1. MSSQL JDBC Driver download
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 } }
|
'Elasticsearch' 카테고리의 다른 글
CentOS 7 Auditbeat 7.0 OSS RPM Install (0) | 2019.04.29 |
---|---|
CentOS 7 Elasticsearch / kibana 7.0 OSS RPM Install (0) | 2019.04.29 |
[elastic] winlogbeat (윈도이벤트 로그 경량 수집기) - 설치 (0) | 2019.03.20 |
[Python] Elasticsearch Monitoring (0) | 2018.07.22 |
[Elasticsearch] Numeric(숫자) Data Types (0) | 2018.07.14 |
Beat(비트) 윈도우 서비스에 등록하기 (0) | 2018.07.02 |
Kibana설치 - Windows 2012 (0) | 2018.06.25 |
Elasticsearch 설치 -Windows 2012 (0) | 2018.06.24 |