I am looking at implementing ES using logstash and Sql server as my data source. I was initially using river to read data from Sql server but one of the developers in my team recommended looking at using logstash. Can anyone point to a guide on how to get started with logstash & sql server. My goal is to do search using elasticsearch.
Thanks
So far, there is no any Logstash API for reading SQL. For input API supported, you can visit here to get more information
For my recommendation, you can write a program to read from sql and write to a file. Then use logstash file API to read from the file. The Logstash website has getting started tutorial. It is easy to learn. Good Luck