# Import data (table) from Oracle to ES **URL:** \ **Category:** Elasticsearch\ **Created:** [March 17, 2017, 11:07am UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006 "2017-03-17T11:07:27Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![AyyappanK](https://avatars.discourse-cdn.com/v4/letter/a/df788c/32.png) [@AyyappanK](https://discuss.elastic.co/u/AyyappanK)\ **Post date:** [March 17, 2017, 11:07am UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006/1 "2017-03-17T11:07:27Z")
Hi All, I am an Oracle developer. We have a requirement to pump in data from Oracle tables to ES and subsequently route to Angular JS for reporting purposes. While I am totally new, to this technology, I have read about JDBC river (which will be obsolete soon), Logstash and RabbitMQ frameworks. All of these are very new to my understanding. Need experts help to choose the best and easy to play with framework to import data from Oracle DB into ES. Regards, Ayyappan ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 17, 2017, 12:01pm UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006/2 "2017-03-17T12:01:08Z")
JDBC River has been replaced a long time ago by elasticsearch-jdbc. See [https://github.com/jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc) You can use this project or Logstash if you have flat data. But I prefer modifying if possible the application which creates data into the Database as I explained in [http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/) ---
**Author:** ![AyyappanK](https://avatars.discourse-cdn.com/v4/letter/a/df788c/32.png) [@AyyappanK](https://discuss.elastic.co/u/AyyappanK)\ **Post date:** [March 17, 2017, 12:16pm UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006/3 "2017-03-17T12:16:30Z")
Thanks David. Modifying the application which creates data is not a feasible option as the upstream application is owned by a different track and we have read only access. Could you please throw more light on how Logstash can be used to import data from Oracle. I have gone through couple of sites on the net but I feel, it is not as straightforward as the Data import handler in Solr or may be it's my perception. As i am new to this, I am excited to explore but the limited options available online and not so straightforward oracle integration available on the net is hampering my progress. Any leads would be appreciated. For the time being, I plan to have a POC implemented in my local machine (Windows OS). I have accessing the Oracle DB server (remote enterprise) which hosts ERP data. Regards, Ayyappan ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 17, 2017, 12:53pm UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006/4 "2017-03-17T12:53:00Z")
You can read [https://www.elastic.co/blog/logstash-jdbc-input-plugin](https://www.elastic.co/blog/logstash-jdbc-input-plugin) to get more information. ---
**Author:** ![AyyappanK](https://avatars.discourse-cdn.com/v4/letter/a/df788c/32.png) [@AyyappanK](https://discuss.elastic.co/u/AyyappanK)\ **Post date:** [March 17, 2017, 6:23pm UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006/5 "2017-03-17T18:23:18Z")
Thanks David. How about RabbitMQ? Heard it is equipped with the below plugin. RabbitMQ-Oracle-Stored-procedures ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 17, 2017, 7:25pm UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006/6 "2017-03-17T19:25:00Z")
I don't know this plugin but if you have data in rabbitmq you can use logstash to read it. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 14, 2017, 7:25pm UTC](https://discuss.elastic.co/t/import-data-table-from-oracle-to-es/79006/7 "2017-04-14T19:25:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.