Elasticsearch for Microsoft SQL Server Data

Hi,
We have a Microsoft SQL Server Database running in Production. Can someone please illustrate on how to access Ms SQL Server Data to Elasticsearch? I found the River technique on Web but also saw that it was already deprecated. Any kind of suggestions, steps, links, resources will be highly appreciated.

Thanks in advance.

1 Like

See this : https://www.elastic.co/blog/logstash-jdbc-input-plugin

The link above uses a PostgreSQL Database, but you can change the configuration for your case using SQL Server JDBC Driver.

1 Like

Also if you need a more real time approach and have access to the application which is writing to the database, I'd encourage reading http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

HTH

1 Like

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