Steps to Install and Configure SQL Server with Logstash


(MG) #1

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!


(Mark Walkom) #2

What OS?


(Joaquim Freitas) #3

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...


(system) #4

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