Customer Portal

Does ETL support clob and blob objects?

Comments 4

  • Avatar
    imriskal
    0
    Comment actions Permalink
    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,
  • Avatar
    ranish.p@gmail.com
    0
    Comment actions Permalink
    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
  • Avatar
    imriskal
    0
    Comment actions Permalink
    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
    Kind regards,
  • Avatar
    ranish.p@gmail.com
    0
    Comment actions Permalink
    Thank you very much.
    I've verified this graph and its addressing the question posted.

Please sign in to leave a comment.