Configure logstash input from DB values

Elastic Stack Logstash
2

hello @Ryan2 welcome :blush:

I understood your requirement -

please follow step/action require by you to perform the same-

Step 01-

You need database driver as per below logstash config.

lostashfile.conf

input {
  jdbc {
    jdbc_driver_library => "C:\Users\xxxx\Downloads\Elasticsearch\sqljdbc_4.2\enu\jre8\sqljdbc42.jar"
    #jdbc_driver_class => "com.microsoft.jdbc.sqlserver.SQLServerDriver"
	jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "jdbc:sqlserver:/XXXXXX;integratedSecurity=false;"
	
    
    jdbc_user => "user"
	jdbc_password => "pass"
	jdbc_validate_connection => true

    statement => "SELECT * FROM table1"
  }
}

output {
  elasticsearch {
    hosts => ["localhost:9200"]
    index => "dbdataindex"
  }
}

after data available as index in elastic search then add use kibana as default config if using localhost.

for more reply

Thanks
HadoopHelp