Tour Spoon Perspectives
Overview
Links to the different perspectives in PDI.
Spoon is an integrated environment enabling you to work in close cooperation with business users to build business intelligence solutions more quickly and efficiently. When you are working in Spoon, you can change perspectives to easily switch back and forth from:
- Designing ETL jobs and transformations—the Data Integration perspective
- Modeling your data—the Model Editor perspective
- Scheduling jobs and transformations—the Schedule perspective
- Visualizing data models—the Visualize perspective
As users provide you with feedback about how the data is presented to them, you can quickly make iterative changes to your data directly in Spoon by changing perspectives. From within Spoon, you can change perspectives using the Perspective menu located in the upper-right corner of the window.
Other perspectives are also available from the marketplace if you install a plugin containing one. For example, if you install the Vizor plugin, the Vizor perspective appears in the drop down menu
Data Integration Perspective
The Data Integration interfaces allows you to create transformations, jobs, and more.
Icon | Description |
---|---|
![]() | Create a new job or transformation |
![]() | Open transformation/job from file if you are not connected to a repository or from the repository if you are connected to one |
![]() | Explore the repository |
![]() | Save the transformation/job to a file or to the repository |
![]() | Save the transformation/job under a different name or file name (Save as) |
![]() | Run transformation/job; runs the current transformation from XML file or repository |
![]() | Pause transformation |
![]() | Stop transformation |
![]() | Preview transformation: runs the current transformation from memory. You can preview the rows that are produced by selected steps. |
![]() | Run the transformation in debug mode; allows you to troubleshoot execution errors |
![]() | Replay the processing of a transformation |
![]() | Verify transformation |
![]() | Run an impact analysis on the database |
![]() | Generate the SQL that is needed to run the loaded transformation. |
![]() | Launch the database explorer allowing you to preview data, run SQL queries, generate DDL and more |
![]() | Show execution results pane |
![]() | Lock transformation |
Model Editor Perspective
The Model Editor perspective is used for designing reporting and OLAP metadata models that can be tested from within the Visualize perspective or published to the Pentaho BA Server.
Visualize Perspective
The Visualize perspective allows you to test reporting and OLAP metadata models created in the Model Editor perspective using the Report Design Wizard and Analyzer clients respectively. See Get Started with Analyzer Reports for more details about the Analyzer client.
Component | Name | Description |
---|---|---|
![]() | Menubar | The Menubar provides access to common features such as properties, actions, and tools. The right side of the menubar is also where you can switch between perspectives. |
![]() | Main Toolbar | The Main Toolbar provides single-click access to common actions such as undoing steps, redoing steps, exporting, adding filters, rearranging the layout, refreshing, setting properties. See Get Started with Analyzer Reports for more details. |
![]() | Field List | Contains the list of measures and attributes as defined in your model. These fields can be dragged into the Report Area to build your query. |
![]() | Layout | Allows you to drag Measures and Levels into the Row, Column, and Measures area so you can control how it appears in the workspace. |
![]() | Canvas | Drag fields from the field list into the Report Area to build your query. Right click on a measure or level to further customize your report with sub-totals, formatting, and more. |