For the complete documentation index, see llms.txt. This page is also available as Markdown.

Hello World

Simple Transformation ..

Workshop - Hello World

  1. Log into Pentaho 11 User Console (PUC).

  1. Select: Pipeline Designer.

Pipeline Designer

Tour of Pipeline Designer UI

For folks familiar with Data Integration the key concepts & features should be familiar ..

  1. Select: Create Transformation in Pipeline Designer.

Pipeline Designer UI
Feature
Description

Collapse the left menu.

Switch bewteen Design & View mode.

Design Panel. You can also 'Search' for Nodes.

Add a Note

Reset the current Transformation. It will clear all Nodes & connections. Cannot be undone.

RUN the Transformation. The drop-down Run Options enable: Run Configuration, Logging Level, Parameters & Variables

Pause RUN.

Stop RUN.

View the Logging, Preview Data & Step Metrics panel.

View the Kettle Status.

View the Transformation Properties.

Zoom in or Out of the Canvas.

Lock the Canvas.

Switch between Design & XML view.

Transformation - Hello World

This workshop assumes you have some experience of using Data Integration. The intended outcome is to famialize yourself with the new features and options in the UI.

  1. Collapse the left-hand menu.

  2. In pipeline Designer, drag & drop the Generate Rows node from Input onto the Canvas.

Drag & Drop - Generate Rows
  1. Drag & Drop the Dummy node from Flow onto the Canvas.

Drag & Drop - Dummy
  1. Create a Hop - place your cursor over the Generate rows output. It will turn to a +. Hold down the left hand mouse button and drag the Hop to the Dummy input.

Create a Hop
  1. Double-clcik on the Generate rows node to configure

Configure Generate rows
  1. Enter the following details:

Setting
Value

Limit

Keep default value of 10 records / rows.

Name

message

Type

String

Value

Hello World

Configure - Generate rows
  1. Click Preview. Enter the number of Preview rows.

Preview data
  1. Click Cancel > Save.

  2. Add a Note - you can also edit the Style.

  1. Click: Save.

Add Note
  1. Before we RUN the transformation, Save as.

  1. Create a Folder: Data Pipelines in 'public'.

  2. Save the transformation.

save transformation - gr:hello-world

Run the Transformation

  1. Click: Run.

Run the transformation

Job - Hello World

  1. From the drop-down box, 'Create new' > Job.

  2. Drag & drop the Start, Transformation & Success nodes onto the Canvas.

  3. Create the required hops. Place your cursor over the hop for more information.

Hop information
  1. Click: Save as and Save the Job in the same folder as the previous hello-world.ktr

Save
  1. Double click on the Transformation node to configure.

  1. Click: Select variable to insert and select: ${Internal.Entry.Current.Directory}/

  2. Add the name of the transformation - hello-world

  3. Click: Save.

  4. Run

x

x

x

x

Last updated

Was this helpful?