How to Integrate Elasticsearch with MS SQL Server


(Amit Shrivastava) #1

Hi

Currently i am trying to integrate Elasticsearch 5.1 with MS SQL 2014, I have gone through the following blog (http://www.j2eebrain.com/java-J2ee-how-to-use-elasticsearch-with-sql-server.html) but i wont help me much.

I have installed the Elasticsearch on my windows system using msi. But i am using it from CMD console.

Can anyone provide me proper steps to integrate this.

Thanks in Advance


(David Pilato) #2

This article is so old (no date but it mentions rivers which have been removed).

Have a look at Logstash JDBC input. That might be a good fit.


(Jerod Johnson) #3

The SSIS Components for Elasticsearch by CData Software offer native integration between SQL Server and Elasticsearch.

There are two accompanying articles for the components:

Importing data into SQL Server
Exporting data from SQL Server


(Mark Walkom) #4

Thanks for sharing that! It'd be great if you could also let people know you work for the company you are promoting in future :slight_smile:


(system) #5

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