Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Passing config.properties file by command line

  1. #1
    Join Date
    Nov 2016
    Posts
    5

    Default Passing config.properties 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
    Code:
    kitchen.bat /file:"path/to/file.kjb" "-param:DB_NAME=name" ...
    My question is, is possible passing a config.properties file by command line, for dynamically set db connection paramenter?

  2. #2
    Join Date
    Nov 2016
    Posts
    5

    Default

    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
    Posts
    15

    Default

    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/kettle.properties.
    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.