Elastic Search to pull data from DB2 at regular intervals


(Ramesh) #1

Hi,

Any one has any idea how Elastic Search can pull data from DB2 at regular intervals.
Can we use Logstash for querying DB2 continuously and push to Elastic Search.

Kindly advice.


(David Pilato) #2

I shared most of my 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.

But if db2 has a jdbc connector you can use logstash jdbc input indeed.