How to export SQL Server Data to Elasticsearch 6.0.0


(Kartheek Gummaluri) #1

Guys I'm trying get the data from sql server 2014 to Elasticsearch 6.0.0 .Please let me know the best possible scenarios.


(Mark Walkom) #2

We aren't all guys :slight_smile:

Have you looked at https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html?


(Kartheek Gummaluri) #3

It is showing us MYSQL plugin does it support sql server.What I'm thinking was we have sql server database where data is getting inserted daily.So I need to run a cron job to sync sql server database to elasticsearch.
So can you tell me how the above mentioned article will work.


(Mark Walkom) #4

If your SQL server supports JDBC then you can use that.


(Kartheek Gummaluri) #5

No Actually we are using sql server 2014 which doesn't support JSON


(system) #6

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