these 3 simple questions surprisingly hard find definite answers.
- does elasticsearch support indexing data in rdbms tables ( oracle/sqlserver/informix) out of box?
- if yes, can please point me documentation on how it
- if not, alternate ways (plugins rivers - deprecated) reputation
i'm surprised there isn't solid answer yet this. here's solution. logstash directly gives ability push data rdbms elasticsearch.
here's link tutorial tell how go it. briefly(all details in link 1), need jdbc driver relational database you'll using (postgres, mysql etc) , make config file specifying input relational database , output elasticsearch. can specify cron allow keep updating 1 regular intervals.
here's article mentions configuration , gets started (see example 2): https://www.elastic.co/blog/logstash-jdbc-input-plugin
here's article tells how configure cronjob such: https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#_scheduling
Comments
Post a Comment