Import data from SQL Server to ElasticSearch

Elastic Stack Elasticsearch
1

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 elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

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 elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.