# Connect Sql Server with Elasticsearch

**URL:** <https://discuss.elastic.co/t/connect-sql-server-with-elasticsearch/107195>\
**Category:** Elasticsearch\
**Created:** [November 10, 2017, 1:53pm UTC](https://discuss.elastic.co/t/connect-sql-server-with-elasticsearch/107195 "2017-11-10T13:53:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mayank.gaur](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@mayank.gaur](https://discuss.elastic.co/u/mayank.gaur)\
**Post date:** [November 10, 2017, 1:53pm UTC](https://discuss.elastic.co/t/connect-sql-server-with-elasticsearch/107195/1 "2017-11-10T13:53:47Z")

</div>

I have installed Elasticsearch on my windows system, but I am not able to find a way to connect with SqlServer.  
Even please help me out for plugin also.

---

<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:** [November 10, 2017, 3:38pm UTC](https://discuss.elastic.co/t/connect-sql-server-with-elasticsearch/107195/2 "2017-11-10T15:38:19Z")

</div>

Elasticsearch des not connect to anything.

Other things connect to elasticsearch.

So you need to read data from your source (SqlServer), transform what you read into JSON documents, and send that to elasticsearch.

Multiple options for that:

- Your code
- Logstash: [https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html)
- Some tools like: [https://github.com/jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc)

I wrote thoughts about this 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/)

---

<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:** [December 8, 2017, 3:38pm UTC](https://discuss.elastic.co/t/connect-sql-server-with-elasticsearch/107195/3 "2017-12-08T15:38:33Z")

</div>

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