Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Setting globally persistent environment variables

  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Default Setting globally persistent environment variables

    Hello, We use PDI Kettle to pull sql reports and email them to end users. Currently each mail step in each job has the mail server directly entered into the step settings. I would like to setup some way for us to have an environment variable for the mail server that each step can use instead of having the server name hardcoded into each individual step. (or better yet if we could setup the mail server like the DB connections). The goal being that if the mail server is changed, we don't have to go through each step and manually change the server name but instead only change it in one place and all the mail steps would automatically send through the new server. Is there a way to do this with kettle? Thanks in advance.

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    The Mail job entry supports variable substitution. Note the little gray/red boxes to the right of the input fields.

    Follow this link for more info: http://wiki.pentaho.com/display/EAI/.07+Variables
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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.