Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Shell Script + Database connectivity help

  1. #1
    Join Date
    Feb 2011
    Posts
    16

    Default Shell Script + Database connectivity help

    Hi All,

    I am very new to pentaho data integration and data warehousing . I need a help on my project. The thing is this . I need to prepare a shell script which collects the logs from the server and move it to DB and should be implemented with kettle transformation. I can see that shell script from jobs and i am just playing around with it. Please help me in achieving this with any step by step approach.

    SHELL --------> (Data transformation)-------------> DATABASE
    |
    EXTERNAL DATA---


    So above is the logic I would want to do

    Thanks in advance,

  2. #2
    Join Date
    Feb 2008
    Posts
    107

    Default

    1. Use Spoon to create a transformation or job to load your database.
    2. Write a shell script which calls the Pan command to run your transformation, or Kitchen to run your job as appropriate.

    More help at http://wiki.pentaho.com/display/EAI/...+Documentation

    Cheers,
    Paul

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.