Data Integration perspective

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-09

The Data Integration perspective allows you to create transformations and jobs. See Data Integration perspective in the PDI client for more details. You can also Inspect your data to make iterative updates as you work.


Data Integration perspective

In the table below, use the numbered items in the illustration above to reference the toolbars, buttons, and areas on the PDI client.

Item Feature Description
1 Toolbar Use this toolbar to access commonly performed actions:
  • New file button ( New file ) to create a new job, transformation, database connection, or slave server.
  • Open file button ( Open file ) to open a transformation or job from a file.
  • Explore Repository button ( Explore repository ) to explore the repositories.
  • Save button ( Save ) to save the current transformation or job to a file or repository.
  • Save As button ( Save as ) to save the transformation or job under a different file name or type.
  • Perspectives button ( Perspectives ) to switch between the different perspectives:
2 Connect button Use this button to access the menu to create and connect to repositories for central storage of your ETL jobs and transformations.
3 Sub-toolbar Use this toolbar to perform transformation or job actions:
  • Run button ( Run ) to run a transformation or job:
    • Run: Runs the current transformation or job from an XML file or a repository.
    • Run Options: Sets the Run Options and then runs the current transformation or job from an XML file or a repository.
  • Pause button ( Pause ) to pause a running transformation or job.
  • Stop button ( Stop ) to stop a running transformation or job:
    • Stop: Stops the transformation or job immediately.
    • Stop input processing: Stops the input steps to the transformation or job, while allowing any records already retrieved or initiated to be processed and then stopped.
  • Preview button ( Preview ) to run the transformation in preview mode to examine the rows produced by the selected steps.
  • Debug button ( Debug ) to run the transformation in debug mode to troubleshoot execution errors.
  • Replay button ( Replay ) to replay the processing of a transformation.
  • Verify button ( Verify ) to verify the transformation.
  • Analyze button ( Analyze ) to run an impact analysis on the database.
  • SQL button ( SQL ) to generate the SQL that is needed to run the loaded transformation.
  • Explore DB button ( ) to launch the Database Explorer to perform actions such as preview data, run SQL queries, and generate DDL.
  • Results button ( ) to show the Execution Results pane.
  • Lock button ( ) to lock the transformation.
4 Explore pane Use this pane to access the Design and View tabs:
  • The Design tab provides a list of steps or entries that are used to build transformations or jobs.
  • The View tab provides information about available database connections and the steps and hops used for the transformation or job.
5 Canvas Use this canvas for designing and building transformations and jobs for the ETL activities you want to perform.