Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Retrieving file from a database

  1. #1
    Join Date
    Oct 2017

    Default Retrieving file from a database


    Is it possible to extract a text file from a database say Oracle and use it as a source in a transformation? If yes, how can i achieve it?


  2. #2
    Join Date
    Jun 2012


    It depends on what you mean with "as a source in a transformation".
    Are you looking for a way to persuade Text-File-Input to read file contents from a CLOB column?
    No way, then, it's not supported by VFS.
    If you must avoid to store files on disk at all cost, you'll have to implement your own parser, I'm afraid.
    It's fairly easy using opencsv, but I would stick to the filesystem approach if possible.
    So long, and thanks for all the fish.

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.