# Elasticsreach5 for SQL server 2012

**URL:** <https://discuss.elastic.co/t/elasticsreach5-for-sql-server-2012/95932>\
**Category:** Elasticsearch\
**Created:** [August 4, 2017, 5:02pm UTC](https://discuss.elastic.co/t/elasticsreach5-for-sql-server-2012/95932 "2017-08-04T17:02:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed.O](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@Ahmed.O](https://discuss.elastic.co/u/Ahmed.O)\
**Post date:** [August 4, 2017, 5:02pm UTC](https://discuss.elastic.co/t/elasticsreach5-for-sql-server-2012/95932/1 "2017-08-04T17:02:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [August 5, 2017, 9:11pm UTC](https://discuss.elastic.co/t/elasticsreach5-for-sql-server-2012/95932/2 "2017-08-05T21:11:19Z")

</div>

Have a look at [https://www.elastic.co/guide/en/logstash/5.5/plugins-inputs-jdbc.html](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/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [August 7, 2017, 9:57am UTC](https://discuss.elastic.co/t/elasticsreach5-for-sql-server-2012/95932/3 "2017-08-07T09:57:33Z")

</div>

@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](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.

---

<div class="post-metadata">

**Author:** ![Ahmed.O](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@Ahmed.O](https://discuss.elastic.co/u/Ahmed.O)\
**Post date:** [August 8, 2017, 10:18am UTC](https://discuss.elastic.co/t/elasticsreach5-for-sql-server-2012/95932/5 "2017-08-08T10:18:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 5, 2017, 10:26am UTC](https://discuss.elastic.co/t/elasticsreach5-for-sql-server-2012/95932/6 "2017-09-05T10:26:38Z")

</div>

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