Run a transformation

Run a transformation to step through the ETL tasks you set up, in the order specified by the transformation.

Complete the following steps to run a transformation:

1. Log into the Pentaho User Console.

2. Open Pipeline Designer:

   • If you are using the Modern Design, in the menu on the left side of the page, click Pipeline Designer.

   • If you are using the Classic Design, click Switch to the Modern Design, and then in the menu on the left side of the page, click Pipeline Designer.

   Pipeline Designeropens with the Quick Access section expanded.

3. In the table at the bottom of the screen, select either the Recently opened or Favorites tab.

4. Open the transformation:

   1. Search for or browse to the transformation, and then click Open.

   2. Click Open files, and then in the Select File or Directory dialog box, search for or browse to the transformation and click Open.

5. In the Canvas Action toolbar, click the Run icon and select one of the following options:

   1. To run the transformation, select Run.

   2. To configure run options and run the transformation, select Run Options, and then in the Run Options window, configure your options and click Run. For details about run options, see Transformation run options.

   The transformation runs and the Preview panel opens with the Logging tab selected.

Note: For information about stopping the transformation while it is running, see Stop transformations and jobs.

Transformation run options

Option	Description
Select configuration	All transformations are run using the Pentaho server configuration.
Clear log before running	Indicates whether to clear all your logs before you run your transformation. If your log is large, you might need to clear it before the next execution to conserve space.
Enable safe mode	Checks every row passed through your transformation and ensures all layouts are identical. If a row does not have the same layout as the first row, an error is generated and reported.
Gather performance metrics	Monitors the performance of your transformation execution. You can view performance metrics in the Pentaho Data Integration client. For details see Use performance graphs.
Log level	Specifies how much logging is performed and the amount of information captured: Nothing: No logging occurs. Error: Only errors are logged. Minimal: Only use minimal logging. Basic: This is the default level. Detailed: Give detailed logging output. Debug: For debugging purposes, very detailed output. Row Level (very detailed): Logging at a row level, which generates a lot of log data. Debug and Row Level logging levels contain information you may consider too sensitive to be shown. Consider the sensitivity of your data when selecting these logging levels. See the Administer Pentaho Data Integration and Analytics guide for instructions on how best to use these logging methods.
Parameters	Applies parameter values pertaining to your transformation during runtime. A parameter is a local variable. For more details, see Parameters.
Variables	Applies temporary values for user-defined and environment variables pertaining to your transformation during runtime. For more details, see Variables.
Arguments	Applies a named, user-supplied, single-value input given as a command line argument when running the transformation manually or with a script. Arguments are handled according to a transformation's design. If the transformation is not designed to handle arguments, nothing happens. Typically, argument values are numbers, words (strings), or system or script variables. Each transformation can have a maximum of 10 arguments. For more details, see Arguments.