Best way to index from SQL since Rivers is deprecated?


(Marius Mathisen) #1

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? :slight_smile:


(Mark Walkom) #2

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


(David Pilato) #3

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 :slight_smile:


(Marius Mathisen) #4

Thank you very much. :slight_smile:


(system) #5