...
| Note | ||
|---|---|---|
| ||
The name you use for repository.name must match a connection defined in Kettle repository.xml file. This file is located by default in the user's home directory (~/.kettle/repositories.xml) It needs to be in the home directory of the effective user that the BI Server is running as. The easiest way to create the files and directories required is to run Spoon on the server machine and do the normal repository setup. This requirement will go away when the following JIRA case is completed: |
Support for Parameters, Variables and Arguments
Parameters, variables and arguments may be passed into PDI Jobs and Transformations by mapping KettleComponent inputs. All values to be sent to the PDI Job / Transformation MUST be included in the 'action-inputs' section of the KettleComponent's 'action-definition' element.
Once the desired values are in the 'action-inputs' section they may be mapped by adding either a 'set-parameter', 'set-variable', or 'set-argument' element into the 'component-definition' section of the KettleComponent's 'action-definition'.
Format for: 'set-parameter':
<set-parameter>
<name>parameterOne</name>
<mapping>inputOne</mapping>
</set-parameter>
Format for: 'set-variable':
<set-variable>
<name>variableOne</name>
<mapping>inputOne</mapping>
</set-variable>
Format for: 'set-argument':
<set-argument>
<name>1</name>
<mapping>inputOne</mapping>
</set-argument>
<set-argument>
<name>2</name>
<mapping>inputTwo</mapping>
</set-argument>
In the above three examples, the 'name' element maps to the name in the PDI Job / Transformation (Except in the case of argument it is, consecutively 1-10, mapping to the expected command line arguments). The 'mapping' element maps to the parameter in 'action-inputs'.
Please see: http://jira.pentaho.com/browse/BISERVER-257 for a more complete example.