# How to import oracle Clob data in a Index of Elastic

**URL:** <https://discuss.elastic.co/t/how-to-import-oracle-clob-data-in-a-index-of-elastic/59837>\
**Category:** Logstash\
**Created:** [September 6, 2016, 1:09am UTC](https://discuss.elastic.co/t/how-to-import-oracle-clob-data-in-a-index-of-elastic/59837 "2016-09-06T01:09:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaudhry\_salil](https://avatars.discourse-cdn.com/v4/letter/c/54ee81/32.png) [@chaudhry\_salil](https://discuss.elastic.co/u/chaudhry_salil)\
**Post date:** [September 6, 2016, 1:09am UTC](https://discuss.elastic.co/t/how-to-import-oracle-clob-data-in-a-index-of-elastic/59837/1 "2016-09-06T01:09:12Z")

</div>

We have big tables with data stored as XML clob in Oracle. Now we need to import this data in Elastic and sure we can't import and store it as XML in elastic. instead want to store it as different field values of a document in elastic.

Has anybody done it ?

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [September 6, 2016, 3:34am UTC](https://discuss.elastic.co/t/how-to-import-oracle-clob-data-in-a-index-of-elastic/59837/2 "2016-09-06T03:34:59Z")

</div>

You should be able to use Logstash's jdbc input and its xml filter.

---

<div class="post-metadata">

**Author:** ![chaudhry\_salil](https://avatars.discourse-cdn.com/v4/letter/c/54ee81/32.png) [@chaudhry\_salil](https://discuss.elastic.co/u/chaudhry_salil)\
**Post date:** [September 6, 2016, 4:55am UTC](https://discuss.elastic.co/t/how-to-import-oracle-clob-data-in-a-index-of-elastic/59837/3 "2016-09-06T04:55:32Z")

</div>

Thanks for the response. Do you have any code sample?

Salil

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [September 6, 2016, 5:25am UTC](https://discuss.elastic.co/t/how-to-import-oracle-clob-data-in-a-index-of-elastic/59837/4 "2016-09-06T05:25:15Z")

</div>

The jdbc input documentation contains a few examples. Start there and verify that you can pull data correctly, then continue with the xml filter.

---

<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:** [July 6, 2017, 4:39am UTC](https://discuss.elastic.co/t/how-to-import-oracle-clob-data-in-a-index-of-elastic/59837/5 "2017-07-06T04:39:46Z")

</div>