Read data from RelationalDatabase to Elasticsearch


(Ramya) #1

Hi

I am bit confused here in reading data from Relational database to elasticsearch,should i use Logstash with jdbc input plugin or elasticsearch jbdc driver , which one fullfill my requirement ?

Please help me.


(David Pilato) #2

You can use Logstash with jdbc input plugin.

But I shared other thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.


(Ramya) #3

Thanks David


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.