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?
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.