Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Can remote execution use remote kettle.properties?

  1. #1
    Join Date
    Oct 2010
    Posts
    13

    Default Can remote execution use remote kettle.properties?

    I am trying to execute kettle jobs/transformations remotely and I thought the kettle.properties were also read remotely. This isn't the case.
    Does anyone know how to use these properties instead of the local ones?

  2. #2
    Join Date
    Nov 2008
    Posts
    143

    Default

    Are you running those remote trans through Carte or Spoon?
    As far as I remember, you can set the KETTLE_HOME environment variable to where you want your properties file read from.
    In case you're running Carte, you'll need to set this variable in each server, pointing to each specific folder.

    On the other hand, I'm not sure you can do this if you run it through Spoon.

    Cheers,

  3. #3
    Join Date
    Mar 2008
    Posts
    140

    Default

    By default the kettle home directory is in ~\.kettle (the users home directory + .kettle) and can therefore depend on the OS and the user running the app (Carte, DI Server, etc...).
    For instance, if you are running the DI Server as a Windows Service, then the Local System account is likely being used and the kettle home directory would not be in your users home directory.

  4. #4
    Join Date
    Nov 2008
    Posts
    143

    Default

    But that doesn't discard the KETTLE_HOME hint, right Clyde?

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    kettle.properties is read by Carte for a number of default values regarding the Carte config. However, variables values are typically sent along with the remote execution configuration of the transformation or job.

Tags for this Thread

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.