How to create multiple indices from multiple oracle databases?

Elastic Stack Logstash
1

I am trying to setup elasticsearch to a 50+ application, those applications hold their own oracle DB. I can use 'logstash' to feed DB-records using logstash.conf file. but it holds single INPUT section,

How can I connect multiple DB to single elasticsearch? how and which tool can help me?

2

you can define multiple input plugins in the input section of logstash

3

@Shaoranlaos Thanks for the comment, to understand it better, do you mean to change current logstash.conf file input section like below,

input {
jdbc {
jdbc_connection_string => "jdbc:oracle:thin:@XXX:15210/XXX"
jdbc_user => "XXX"
jdbc_password => "XXX"
statement => "XXX"
jdbc_driver_library => "/usr/share/logstash/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
}
jdbc {
jdbc_connection_string => "jdbc:oracle:thin:@YYY:15210/YYY"
jdbc_user => "YYY"
jdbc_password => "YYY"
statement => "YYY"
jdbc_driver_library => "/usr/share/logstash/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
}
jdbc {
jdbc_connection_string => "jdbc:oracle:thin:@ZZZ:15210/ZZZ"
jdbc_user => "ZZZ"
jdbc_password => "ZZZ"
statement => "ZZZ"
jdbc_driver_library => "/usr/share/logstash/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
}
}

4

yes that should work

5

It don't work that way. i find another way - its simple. you can put as many files as you can at directory
/etc/logstash/conf.d/
logstash will read them all.

6

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