# How to create multiple indices from multiple oracle databases? **URL:** \ **Category:** Logstash\ **Created:** [March 8, 2018, 9:42am UTC](https://discuss.elastic.co/t/how-to-create-multiple-indices-from-multiple-oracle-databases/123033 "2018-03-08T09:42:05Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![heisjustgod](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/heisjustgod/32/28560_2.png) [@heisjustgod](https://discuss.elastic.co/u/heisjustgod)\ **Post date:** [March 8, 2018, 9:42am UTC](https://discuss.elastic.co/t/how-to-create-multiple-indices-from-multiple-oracle-databases/123033/1 "2018-03-08T09:42:05Z")
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? ---
**Author:** ![Shaoranlaos](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@Shaoranlaos](https://discuss.elastic.co/u/Shaoranlaos)\ **Post date:** [March 8, 2018, 10:53am UTC](https://discuss.elastic.co/t/how-to-create-multiple-indices-from-multiple-oracle-databases/123033/2 "2018-03-08T10:53:45Z")
you can define multiple input plugins in the input section of logstash ---
**Author:** ![heisjustgod](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/heisjustgod/32/28560_2.png) [@heisjustgod](https://discuss.elastic.co/u/heisjustgod)\ **Post date:** [March 8, 2018, 1:06pm UTC](https://discuss.elastic.co/t/how-to-create-multiple-indices-from-multiple-oracle-databases/123033/3 "2018-03-08T13:06:12Z")
@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" } } ---
**Author:** ![Shaoranlaos](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@Shaoranlaos](https://discuss.elastic.co/u/Shaoranlaos)\ **Post date:** [March 8, 2018, 1:19pm UTC](https://discuss.elastic.co/t/how-to-create-multiple-indices-from-multiple-oracle-databases/123033/4 "2018-03-08T13:19:46Z")
yes that should work ---
**Author:** ![heisjustgod](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/heisjustgod/32/28560_2.png) [@heisjustgod](https://discuss.elastic.co/u/heisjustgod)\ **Post date:** [April 4, 2018, 1:08pm UTC](https://discuss.elastic.co/t/how-to-create-multiple-indices-from-multiple-oracle-databases/123033/5 "2018-04-04T13:08:16Z")
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. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 2, 2018, 1:08pm UTC](https://discuss.elastic.co/t/how-to-create-multiple-indices-from-multiple-oracle-databases/123033/6 "2018-05-02T13:08:29Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.