# Connecting Elasticsearch from SQL Server **URL:** \ **Category:** Elasticsearch\ **Created:** [September 19, 2019, 6:12pm UTC](https://discuss.elastic.co/t/connecting-elasticsearch-from-sql-server/200286 "2019-09-19T18:12:31Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![lmariselvam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lmariselvam/32/54542_2.png) [@lmariselvam](https://discuss.elastic.co/u/lmariselvam)\ **Post date:** [September 19, 2019, 6:12pm UTC](https://discuss.elastic.co/t/connecting-elasticsearch-from-sql-server/200286/1 "2019-09-19T18:12:31Z")
I would like to connect my Elasticsearch instance from Microsoft SQL Server to query the JSON data present in an index and process the queried data with Native JSON functions available in SQL Server. Is there any options available to connect Elasticsearch from SQL Server ? ---
**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:** [September 20, 2019, 12:43pm UTC](https://discuss.elastic.co/t/connecting-elasticsearch-from-sql-server/200286/2 "2019-09-20T12:43:09Z")
I shared most of my thoughts there: [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/) Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 18, 2019, 12:43pm UTC](https://discuss.elastic.co/t/connecting-elasticsearch-from-sql-server/200286/3 "2019-10-18T12:43:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.