Skip to main content
Pentaho Documentation

Work with Transformations and Jobs in the Data Integration Perspective

Overview

Quisque mattis rutrum ligula et pellentesque. Pellentesque massa enim, pulvinar quis quam quis, aliquet dapibus augue. Aliquam feugiat suscipit turpis, nec ultrices dolor adipiscing ut.

The Data Integration perspective of Spoon enables you to create two basic file types:

  • Transformations are used to perform ETL tasks.
  • Jobs are used to orchestrate ETL activities, such as defining the flow and dependencies for what order transformations should be run, or preparing for execution by checking conditions.

The following sections describe how to use these transformations and jobs within the Data Integration perspective of Spoon:

Section Description
Terminology and Basic Concepts Learn about terms like transformation, step, hop, and job.
Customizing the Spoon Interface Adjust the look and feel of Spoon to your tastes.
Working with Transformations Discover how to create and use transformations.
Working with Jobs Discover how to create and use jobs.
Arguments, Parameters, and Variables Learn how to work with user inputs.
Performance Monitoring and Logging Configure logging to monitor transformation or job progress.
Interact with Web Services Determine what must occur if your transformation or job interacts with a web service.
Using the SQL Editor Learn how to generate SQL statements.
VFS File Dialogues in Spoon Learn what steps and plugins use Virtual File System (VFS) dialogues.
Reusing Transformation Flows with Mapping Steps Learn how to map commonly used steps into their own steps.
Documenting Transformations and Jobs Create and manage notes to your transformations and jobs.