Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Assistance passing variables for sftp job

  1. #1
    Join Date
    Aug 2011

    Default Assistance passing variables for sftp job

    From what I gather, this is entirely possible, but I'm not finding the exact documentation for doing this.

    I have a very simple job. It uses get file sftp mostly.

    Setting that up isn't really an issue, what is an iss is that I've been asked to make it more modular so we can user it for other clients.

    So, it's been suggested that we read the config from a txt file.

    This is how I think the workflow should go.

    Read in csv file with sftp setting. Site name, port, directory, username, password, local directory, etc...

    Then I need to pass those variables along the chain to the sftp job, where it looks like I can use a variable like $(SERVER_NAME), ${PORT}, etc... in the actual config fot get file sftp.

    Is that possible and and anyone point out more specific docs then just the named parameter page?


  2. #2
    Join Date
    Nov 2008


    The Set Variables job entry might be a good option. It can read a properties file and define those variables for you. There could be a different properties file for each client.
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  3. #3
    Join Date
    Dec 2010



    Have a transformation which has Excel Input to set variables(copy rows to result, in case we need to use loop). In excel input all the ftp parameters are imported and set to variables.

    Call the transformation inside a job and add SFTP step , inside that give the parameters as variables or URI (refer )

    Back to Pentaho

    'Be the best Pearl in the ocean of wisdom'

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.