Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Ways to make user friendly parameters pass through?

  1. #1
    Join Date
    Oct 2008
    Posts
    28

    Unhappy Ways to make user friendly parameters pass through?

    I would like to create an ETL solution where a user can have an easy way to drive the day to day operation. For example, if the user wants to change today's transformation from JUN to MAR, he/she can make a change on a parameter file. This parameter file gets read by PDI in a transformation and work its magic.

    Now I considered XML Input which is ok for developers but not business users.

    Then I consider Excel Input. But the way it reads are like column records:

    Start Period, End Period, Metadata Directory, Data Directory
    JUN, SEP, c:\metadata, c:\data

    ...but the problem is I have over 50 parameters and editing 50 columns is not intuitive.

    Does anyone know of a way where I can read in parameters like Windows .ini file where:

    Start_Period=JUN
    End_Period=SEP
    Metadata_Dir=c:\metadata
    Data_Dir=c:\data

    and each of the variable/value pair will be read into the transformation, parsed and become their own variable.

    How do you do this in a transformation? Thanks for any help.

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

    Default

    This type of file is in our terminology a Properties file.

    http://en.wikipedia.org/wiki/.properties

    Input steps are provided. Since you are getting key/value pairs, you need a few lines of JavaScript to set the variables. (see the setVariable() sample)

    Matt

  3. #3
    Join Date
    Mar 2009
    Posts
    137

    Default

    You can read those files using the "Property Input" and normally you use two fields with it (e.g. key and value)... works pretty good - at least for me so far

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.