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 ?
I shared most of my thoughts there: 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.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.