# How to Put Elasticsearch data to Oracle Table **URL:** \ **Category:** Logstash\ **Created:** [September 30, 2020, 11:57am UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498 "2020-09-30T11:57:47Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![tusharnemade](https://avatars.discourse-cdn.com/v4/letter/t/67e7ee/32.png) [@tusharnemade](https://discuss.elastic.co/u/tusharnemade)\ **Post date:** [September 30, 2020, 11:57am UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/1 "2020-09-30T11:57:48Z")
Hi Could you please help me with my requirement of putting Elasticsearch index data into oracle table. Do we have any additional plugin required for logstash to achieve same. ? I am aware of CSV method , but its too time taking activity and it requires many softwares to be installed on machine to achieve end-to-end results. Thanks Tushar Nemade ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [September 30, 2020, 12:56pm UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/2 "2020-09-30T12:56:12Z")
There is a [jdbc output](https://github.com/theangryangel/logstash-output-jdbc) plugin written by a third party. It is not supported by elastic and the person who wrote it has not modified it in over a year, so it is not clear that they are supporting it either. ---
**Author:** ![tusharnemade](https://avatars.discourse-cdn.com/v4/letter/t/67e7ee/32.png) [@tusharnemade](https://discuss.elastic.co/u/tusharnemade)\ **Post date:** [September 30, 2020, 1:18pm UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/3 "2020-09-30T13:18:06Z")
Hi angryangel some name ... he has written it and not longer supports it as per new version of logstash / elasticsearch.. Anything else from logstash itself ... ? Thanks Tushar Nemade ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [September 30, 2020, 1:20pm UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/4 "2020-09-30T13:20:32Z")
> [@tusharnemade](#): > > Anything else from logstash itself ... ? Not that I know of. ---
**Author:** ![ropc](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ropc/32/47022_2.png) [@ropc](https://discuss.elastic.co/u/ropc)\ **Post date:** [September 30, 2020, 1:27pm UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/5 "2020-09-30T13:27:54Z")
Hi @tusharnemade - @Badger is correct. [logstash-output-jdbc](https://github.com/theangryangel/logstash-output-jdbc) is not a supported plugin (c.f [support matrix](https://www.elastic.co/support/matrix#matrix_logstash_plugins)). It has not been updated in years and the entire repository has been archived which indicates the owner has no intention of doing anything with it. Out of curiosity, why would you need to push Elasticsearch data into a database? ---
**Author:** ![tusharnemade](https://avatars.discourse-cdn.com/v4/letter/t/67e7ee/32.png) [@tusharnemade](https://discuss.elastic.co/u/tusharnemade)\ **Post date:** [September 30, 2020, 1:32pm UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/6 "2020-09-30T13:32:19Z")
Hi We have application metrics and logs data getting pushed into elasticsearch , from multiple apps. We need to filter those and put them into oracle table , for business purpose were oracle comes into picture... ---
**Author:** ![ropc](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ropc/32/47022_2.png) [@ropc](https://discuss.elastic.co/u/ropc)\ **Post date:** [September 30, 2020, 1:51pm UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/7 "2020-09-30T13:51:37Z")
Thanks for the clarifications @tusharnemade - Logstash will not be able to push data into the Oracle database. However, you could think of an architecture where your client applications are sending data to a middleware (e.g Kafka). Both Elasticsearch and Oracle could then consume the same data from Kafka. For example: - You could use the [kafka input plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-kafka.html) to read the data from Kafka and then push the data to Elasticsearch. - You could use the [Kakfa Connect JDBC](https://www.confluent.io/hub/confluentinc/kafka-connect-jdbc) to sink the data from the Kakfa topics into the Oracle database (c.f [JDBC Sink Connector for Confluent Platform](https://docs.confluent.io/5.5.1/connect/kafka-connect-jdbc/sink-connector/index.html)). This is just a suggestion - there could be other approaches - that might require more architectural thinking to address this use case 🙂 ---
**Author:** ![tusharnemade](https://avatars.discourse-cdn.com/v4/letter/t/67e7ee/32.png) [@tusharnemade](https://discuss.elastic.co/u/tusharnemade)\ **Post date:** [October 1, 2020, 2:48am UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/8 "2020-10-01T02:48:26Z")
Appreciated your response @ropc. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 29, 2020, 2:48am UTC](https://discuss.elastic.co/t/how-to-put-elasticsearch-data-to-oracle-table/250498/9 "2020-10-29T02:48:26Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.