Hello World
Simple Transformation ..
Workshop - Hello World
In this hands-on workshop, you'll learn the core mechanics of building transformations in Pipeline Designer. You'll work with nodes, hops, and notes to create a simple Transformation & Job.
What You'll Accomplish:
Create a new transformation from scratch
Add and configure transformation nodes (Generate Rows and Dummy)
Add and configure job nodes (Start, Transformation, Success)
Connect nodes using hops to define data flow
Add notes to document your transformation
Preview data to verify your logic
Interpret the execution metrics
Understand the Logging and Step Metrics tabs for monitoring
By the end of this workshop, you'll have completed your first working transformation & job and established a repeatable development workflow: add nodes, configure properties, preview data, connect with hops, and run.
Prerequisites: Pipeline Designer installed and configured
Estimated Time: 10 minutes
Log into Pentaho 11 User Console (PUC).
Select: Pipeline Designer.
Tour of Pipeline Designer UI
For folks familiar with Data Integration the key concepts & features should be familiar ..
Select: Create Transformation in Pipeline Designer.
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.
Collapse the left-hand menu.
In pipeline Designer, drag & drop the Generate Rows node from Input onto the Canvas.
Drag & Drop the Dummy node from Flow onto the Canvas.
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.
Double-clcik on the Generate rows node to configure
Enter the following details:
Limit
Keep default value of 10 records / rows.
Name
message
Type
String
Value
Hello World
Click Preview. Enter the number of Preview rows.
Click Cancel > Save.
Add a Note - you can also edit the Style.
Click: Save.
Before we RUN the transformation, Save as.
Create a Folder: Data Pipelines in 'public'.
Save the transformation.
Click: Run.
From the drop-down box, 'Create new' > Job.
Drag & drop the Start, Transformation & Success nodes onto the Canvas.
Create the required hops. Place your cursor over the hop for more information.
Click: Save as and Save the Job in the same folder as the previous hello-world.ktr
Double click on the Transformation node to configure.
Click: Select variable to insert and select: ${Internal.Entry.Current.Directory}/
Add the name of the transformation - hello-world
Click: Save.
Run
x
x
x
x
Last updated
Was this helpful?