Nastavenie logstash:

input {
    jdbc {
        jdbc_validate_connection => false
        # The path to our downloaded jdbc driver
        jdbc_driver_library => "/opt/mssql-jdbc-12.2.0.jre8.jar"
        # The name of the driver class for SqlServer
        jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
        jdbc_connection_string => "jdbc:sqlserver://192.168.1.40:1433;databaseName=epcDev;user=mato;password=mato;encrypt=false;"
        jdbc_user => "hasin"
        jdbc_password => "hasin12345"
        statement => "SELECT * FROM mato"
        schedule => "* * * * *"

       }
}


filter { }


output {
    elasticsearch {
        "hosts" => "localhost:9200"
        "index" => "index_name"


    }

}

   Send article as PDF