Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Binary blob export

  1. #1
    Join Date
    May 2010
    Posts
    4

    Default Binary blob export

    I have images stored as binary data in an Oracle blob field. I want to retrieve the data and store it on the file system as say a .jpg file. Is there any way to do this with Pentaho?

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    if I recall correctly Kettle ships with a sample of how to do that in the samples directory.
    This article also explains it:
    http://type-exit.org/adventures-with...lobs-to-files/

    I'm sure I've seen something on the Pentaho wiki or Matt's Blog too. Google it

    Cheers

    Slawo

  3. #3
    Join Date
    May 2010
    Posts
    4

    Default

    Thanks Slawo! That's what i was looking for.

  4. #4
    Join Date
    Sep 2009
    Posts
    810

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.