This question was probably asked multiple times but I still can't find definite answer.
I have a table in a SQL Server database. Data inserted into the table constantly. Nothing gets deleted or updated. Each row has unique id and date column. I want to index this table in ES. Initial index plus all the new inserts coming in. If possible to create a separated index per day.
What is available today. I see that revers deprecated. Found this JDBC importer. is that's the one to use? Logstash?
Thanks in advance.