Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How can I make it?

  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Default How can I make it?

    I'm new to kettle.
    My scenario is:
    1.get filenames from a folder order by time.
    3.loop
    2.get one file from the filenames result.
    3.read the file.
    4.import the data of the file to db.
    5.move the file to the backup dir.
    6.end loop.

    I can code it easily. How does the kettle make it?

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    Since you're just starting with kettle, this post may also apply to you:
    http://forums.pentaho.com/showthread...my-web-project

    After looking at the docs it may be useful to have a look at the examples in the samples folder that comes with Kettle

    As for the specific scenario, I think a common approach would be to build a job that fetches the files (maybe using a short transformation for that) and passes them to a transformation that does the db import. After the db-import transformation is finished the job would move the file to a backup location.

    Cheers

    Slawo

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.