Since Rivers plugin is deprecated now,what would be an ideal tool/plugin to sync ES indexes with SQL Server data.
It looks like logstash supports jdbc plugin,but is that an ideal way to sync ES indexes with delta/incremental changes
I prefer doing that in the application layer if possible.
See what I wrote here: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/
https://github.com/jprante/elasticsearch-jdbc is also a good candidate