# Does ETL support clob and blob objects?

**URL:** <https://forum.cloverdx.com/t/does-etl-support-clob-and-blob-objects/1273>\
**Category:** CloverDX Platform\
**Created:** [September 17, 2013, 12:00am UTC](https://forum.cloverdx.com/t/does-etl-support-clob-and-blob-objects/1273 "2013-09-17T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![varkashy](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@varkashy](https://forum.cloverdx.com/u/varkashy)\
**Post date:** [September 17, 2013, 12:00am UTC](https://forum.cloverdx.com/t/does-etl-support-clob-and-blob-objects/1273/1 "2013-09-17T00:00:00Z")

</div>

Hi Guys

I have one requirement where in i need to load clob or BLOB data object into endeca data store.  
From the documents i could see Endeca supports only  
Boolean,Numeric,dateTime and String.

Is there a way to load image objects to data domains?

---

<div class="post-metadata">

**Author:** ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)\
**Post date:** [September 17, 2013, 2:08pm UTC](https://forum.cloverdx.com/t/does-etl-support-clob-and-blob-objects/1273/2 "2013-09-17T14:08:44Z")

</div>

Hi varkashy,

Answer to this question is unfortunately outside the scope of CloverETL Support as we do not have any detailed knowledge of Endeca Data Store. Please contact Endeca support instead.

If you had some general database and you wanted to save an image into blob field, you could use metadata with byte field.

Kind regards,

---

<div class="post-metadata">

**Author:** ![ranish.pgmail.com](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/ranish.pgmail.com/32/83_2.png) [@ranish.pgmail.com](https://forum.cloverdx.com/u/ranish.pgmail.com)\
**Post date:** [September 24, 2013, 12:22pm UTC](https://forum.cloverdx.com/t/does-etl-support-clob-and-blob-objects/1273/3 "2013-09-24T12:22:47Z")

</div>

Lubos Imriska,

Thanks for the reply. I am also facing exactly issue as reported by varkashy.  
I have a source field in oracle DB as a BLOB field which have a content of some text data in RTF format.

But when I used metadata as byte - only first character of the content is showing. Is there any way that I can get the full data ?  
(Integrator version I am using is : Version: 3.0.0.1 r729804 )

Please let me know I need to open a new thread for this.

Thanks  
Ranish

---

<div class="post-metadata">

**Author:** ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)\
**Post date:** [September 24, 2013, 3:49pm UTC](https://forum.cloverdx.com/t/does-etl-support-clob-and-blob-objects/1273/4 "2013-09-24T15:49:43Z")

</div>

Dear Ranish,

I am attaching my testing graph created in CloverETL Designer 3.5.0-M1. It is able to read an input rtf file, save it to Oracle 11 XE database table with BLOB column, read it from the db again and save it as a new file. It may help you with your graph. If it did not help, I recommend you to contact Endeca support directly.  
[bytes.grf](https://cdn.cloverdx.com/forum/16493%5Fb2b595fd331dfd962cd4d2108aa652a3/bytes.grf)  
Kind regards,

- [bytes.grf](https://cdn.cloverdx.com/forum/16493%5Fb2b595fd331dfd962cd4d2108aa652a3/bytes.grf)

---

<div class="post-metadata">

**Author:** ![ranish.pgmail.com](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/ranish.pgmail.com/32/83_2.png) [@ranish.pgmail.com](https://forum.cloverdx.com/u/ranish.pgmail.com)\
**Post date:** [September 25, 2013, 6:36am UTC](https://forum.cloverdx.com/t/does-etl-support-clob-and-blob-objects/1273/5 "2013-09-25T06:36:16Z")

</div>

Thank you very much.  
I’ve verified this graph and its addressing the question posted.