Best way to index from SQL since Rivers is deprecated?

[Marius_Mathisen]

Hi there,

I am just starting out with Elastic and it´s products. Right now I am setting up a test environment and I want to index the data stored in a MS SQL server. Before digging any deeper I thought Rivers was the answer, but I see now that is being deprecated.

So what are the best way to index data from a SQL server without using Rivers? Anyone that can point me in the right direction?

[warkolm (Mark Walkom)]

I'd suggest you search the forums, this has been asked multiple times before

[dadoonet (David Pilato)]

If you have access to the application which stores the data in your DB, do it from there.

See http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

If not, have a look at logstash input JDBC (WIP) or the jdbc-river (its old name) which is not anymore a river but a standalone project thanks to @jprante

[Marius_Mathisen]

Thank you very much.