Logstash error to configure java 11 - sql server

Error logstash to configure java 11 to make sql server data etl

{"logstash.version"=>"7.3.1"}

input {
jdbc {
jdbc_driver_library => "/etc/logstash/sql/sqljdbc_7.4/enu/mssql-jdbc-7.4.1.jre11.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://srvbancoTESTE,1433;databaseName=DB_Teste"
jdbc_user => "elasticSearch"
jdbc_password => "******"
tracking_column = IdArtigo
use_column_value = true
statement => "select top 100 * from dbo.textos where IdArtigo > :sql_last_value"
}
}

Add your filters / logstash plugins configuration here.

output {
elasticsearch {
hosts => "elasticsearch:9200"
index => "jornal"
document_type => "artigo"
document_id => "%{IdArtigo}"

    }

}

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