Steps to Install and Configure SQL Server with Logstash

[Minasys (MG)]

I'm trying to find a step by step tutorial to install and configure SQL Server with Logstash or Elasticsearch and I can't find full ones. I need help doing that as I'm new to Elasticsearch!

[warkolm (Mark Walkom)]

What OS?

[Joaquim_Freitas]

Hi,

MSSQL Server will be Windows.

Whatever OSes you'll run Logstash/Elastic, You'll surely need to Download Microsoft JDBC Driver for SQL Server - at least for Logstash.

Then you'll only need to configure the JDBC Plugin accordingly (as documented):

jdbc_driver_library => "<somepath>/mssql-jdbc-6.2.2.jre8.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string =>
  "jdbc:sqlserver://<mssqlhost>:<mssqlport>;databaseName=<mssqldb>"

And the rest its history.

Been there, done that...