Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Retrieving file from a database

  1. #1
    Join Date
    Oct 2017
    Posts
    1

    Default Retrieving file from a database

    Hi,

    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?

    Thanks,

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    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.