Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

Tour Spoon


Presents a diagram of the Spoon interface.


Component Name Name Function
File:/grCallout1.png Toolbar Single-click access to common actions such as create a new file, opening existing documents, save and save as.
File:/grCallout2.png Perspectives Toolbar Switch between the different perspectives.
  • Data Integration — Create ETL transformations and jobs
  • Instaview — Use pre-made templates to create visualizations from PDI transformations
  • Visualize — Test reporting and OLAP metadata models created in the Model perspective using the Report Design Wizard and Analyzer clients
  • Model Editor — Design reporting and OLAP metadata models which can be tested right from within the Visualization perspective or published to the Pentaho BA Server
  • Schedule — Manage scheduled ETL activities on the Data Integration Server
File:/grCallout3.png Sub-toolbar Provides buttons for quick access to common actions specific to the transformation or job such as Run, Preview, and Debug.
File:/grCallout4.png Design and View Tabs

The Design tab of the Explore pane provides an organized list of transformation steps or job entries used to build transformations and jobs. Transformations are created by simply dragging transformation steps from the Design tab onto the canvas and connecting them with hops to describe the flow of data.

The View tab of the Explore pane shows information for each job or transformation. This includes information such as available database connections and which steps and hops are used.

In the image, the Design tab is selected.

File:/grCallout5.png Canvas Main design area for building transformations and jobs describing the ETL activities you want to perform


Table 1. Spoon Icon Descriptions
Icon Description
new.png Create a new job or transformation
open.png Open transformation/job from file if you are not connected to a repository or from the repository if you are connected to one
exploreRepo.png Explore the repository
save.png Save the transformation/job to a file or to the repository
saveas.png Save the transformation/job under a different name or file name (Save as)
run.png Run transformation/job; runs the current transformation from XML file or repository
pause.png Pause transformation
stop.png Stop transformation
preview.png Preview transformation: runs the current transformation from memory. You can preview the rows that are produced by selected steps.
debug.png Run the transformation in debug mode; allows you to troubleshoot execution errors
replay.png Replay the processing of a transformation
check.png Verify transformation
impact.png Run an impact analysis on the database
SQLbutton.png Generate the SQL that is needed to run the loaded transformation.
exploredb.png Launch the database explorer allowing you to preview data, run SQL queries, generate DDL and more
show-results.png Show execution results pane
lock.png Lock transformation