Running an External Program

An Execute Program stage invokes an executable, such as a program or command line command, when it receives a record. To use an Execute Program stage in your dataflow:

Options

Option Description

Command-line

The executable name and arguments (if applicable). The arguments can be data available in the dataflow. To access that data, click the [...] (Browse) button. You can select from the following three contexts: Current Job ID, Current Job Name, or Current User Name. You can also select from the available fields. For example, JobStatus and JobComment.

Timeout

Specifies whether to cancel the execution if the command does not respond within a given amount of time. One of the following:

No timeout
Do not cancel the execution if the command fails to respond.
Timeout in milliseconds
Cancels the execution attempt if the command does not respond in the specified number of milliseconds.

Environment Variables

Optional. Specifies environment variables to use when executing the command. To add an environment variable click Add.

Enter the appropriate key word in the Key field. An example might be "JAVA_HOME".

Enter the appropriate value in the Value field. An example might be C:\Java\jre7. Alternatively, you can select a field from the Field List dialog box by clicking the [...] (Browse) button. You can select from the following three contexts: Current Job ID, Current Job Name, or Current User Name. You can also select from the available fields. For example, JobStatus and JobComment.