logstash同步sqlserver数据

测试版本：

1. elasticsearch 7.10.2
2. kibana 7.10.2
3. logstash 7.10.2
4. jdk java-11.0.10

sqlserver驱动：https://pan.baidu.com/s/1HmbTWlXB0sQgfhBU28iZKA
提取码：ox78

1、新建索引index：test2

2、新建配置文件：sqlserver.conf

input {
  jdbc {
	  jdbc_connection_string => "jdbc:sqlserver://192.168.8.210:1433;DatabaseName=LTT_Distributors;"
	  jdbc_user => "sa"
	  jdbc_password => "Ltt1324."
	  jdbc_driver_library => "D:\logstash\connector\sqljdbc_8.4\chs\mssql-jdbc-8.4.1.jre11.jar"
	  jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
	  jdbc_paging_enabled => "true"
	  jdbc_page_size => "50"
	  statement => "SELECT * from OrderProducts"
          schedule => "* * * * *"
          lowercase_column_names => false
  }    
}


output {
  elasticsearch {
	  hosts => "127.0.0.1:9200" 
	  index => "order_products"
	  document_id => "%{OrderProductID}"
  }
  stdout {
      codec => json_lines
  }
  
}

4、执行：

logstash -f ./config/sqlserver.conf

5、查询数据

GET /test2/_search