# JDBC plugin to ingest data in to elastic search 5.0

**URL:** <https://discuss.elastic.co/t/jdbc-plugin-to-ingest-data-in-to-elastic-search-5-0/69340>\
**Category:** Elasticsearch\
**Created:** [December 17, 2016, 10:24am UTC](https://discuss.elastic.co/t/jdbc-plugin-to-ingest-data-in-to-elastic-search-5-0/69340 "2016-12-17T10:24:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![btom](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/btom/32/13953_2.png) [@btom](https://discuss.elastic.co/u/btom)\
**Post date:** [December 17, 2016, 10:24am UTC](https://discuss.elastic.co/t/jdbc-plugin-to-ingest-data-in-to-elastic-search-5-0/69340/1 "2016-12-17T10:24:57Z")

</div>

Hi,

I am planning to use elastic search 5.0 and needs to ingest data using JDBC to elastic search. I found a plugin [JDBC importer](https://github.com/jprante/elasticsearch-jdbc) created by jprante but it seems that this does not support elastic search 5.0 till yet.

I also found following :

1. [Apache camel elastic search component](http://camel.apache.org/elasticsearch.html)
2. [Logstash JDBC input plugin.](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html)

Just wondering is any recommendation for 1 & 2 above ? Or any other alternative plugin/tool to insert data in to elastic search 5.0 using JDBC?

---

<div class="post-metadata">

**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:** [December 17, 2016, 11:33am UTC](https://discuss.elastic.co/t/jdbc-plugin-to-ingest-data-in-to-elastic-search-5-0/69340/2 "2016-12-17T11:33:40Z")

</div>

My vote goes for 2.

If your documents are a bit complex, I'd encourage modifying if possible the application which is writing in the DB.

I wrote this a while ago:

[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/)

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [December 17, 2016, 12:35pm UTC](https://discuss.elastic.co/t/jdbc-plugin-to-ingest-data-in-to-elastic-search-5-0/69340/3 "2016-12-17T12:35:29Z")

</div>

@btom I'm in the process of migrating JDBC importer to ES 5.x, it will take a while, since this is a spare time project. For progress, see the 5.0 branch

> **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc/tree/5.0)**
>
> elasticsearch-jdbc - JDBC importer for Elasticsearch

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 14, 2017, 12:36pm UTC](https://discuss.elastic.co/t/jdbc-plugin-to-ingest-data-in-to-elastic-search-5-0/69340/4 "2017-01-14T12:36:15Z")

</div>

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