Elasticsreach5 for SQL server 2012

Elastic Stack Elasticsearch
1

Hi ELK Team,

I have been looking for getting SQL server data into elasticsearch, i have gone through several links, nothing worked (JDBC importer also seams doesn't work with elasticsearch5). can anybody from team assist or guide do we have any other way to do that either using logstash or using anything directly with elasticsearch.

With thanks,
Ahmed

2

Have a look at https://www.elastic.co/guide/en/logstash/5.5/plugins-inputs-jdbc.html
About JDBC Importer, indeed it seems that 5.x is not supported. @jprante might tell more about his plans regarding this.

If you have access to the application layer which is generating the data in SQL Server, I'd recommend modifying it to send the JSON doc to elasticsearch within the same "transaction" as you send the data to SQL Server. Read http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

3

@Ahmed.O you are right, JDBC importer does not work with ES 5.x yet. I look forward to have more spare time for programming. Also I look forward to ES 6.

I learned about https://github.com/Microsoft/mssql-jdbc which has MIT license, I hope this is a suitable JDBC driver, it could be included into my JDBC importer project.

5

Thanks @dadoonet, @jprante, Appreciate your effort towards possible direction and Information. @jprante Best of luck for your project!!!

6

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