Import data from SQL Server to ElasticSearch

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Import data from SQL Server to ElasticSearch

OffensivelyBad-2
I'm new to Elasticsearch, but I have a need to import data from a current SQL Server to an Elasticsearch server.

I've looked into some options including a river and bulk import.  Setting up a river is not ideal for this circumstance since only specific data is needed in Elasticsearch, and I need to limit database traffic.

Ideally I would like to be able to run a command, perhaps through the "Any Request" panel of ElasticSearch Head (since it has a built-in "repeat request" option; ex. repeat every hour).  Is it possible to write a PUT request that is able to run a query on SQL Server and then store/index that data in ElasticSearch?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Import data from SQL Server to ElasticSearch

OffensivelyBad-2
As a follow up, would it be possible for elasticsearch to connect to a webservice in increments?  In my scenario, it may be better to have elasticsearch call a webservice (and pass in parameters) and have that service query the database and return a JSON document.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.