Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Passing file by command line

  1. #1
    Join Date
    Nov 2016

    Default Passing file by command line

    I've seen from the documentation that is possible to pass a parameters for DB connection by command line using this syntax
    kitchen.bat /file:"path/to/file.kjb" "-param:DB_NAME=name" ...
    My question is, is possible passing a file by command line, for dynamically set db connection paramenter?

  2. #2
    Join Date
    Nov 2016


    Done! I've make this transformation

    after in my job I have included this transformation as first step, in this

    Now my question is: Is strictly necessary set the parameter and value for every transformation in the job?

    There a manner for not set this parameter in the job?

    Thank you

  3. #3
    Join Date
    Oct 2014


    You need only set the parameters in the main job.
    An alternative to set DB connection is to create uniq db connection for each DB, share them (stored in .kettle/share.xml) but using uniq (fore each connection) variables defined in .kettle/
    Then you don't need to specified them in as parameters in each job.

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.