Presents a diagram of the Spoon interface.
|Toolbar||Single-click access to common actions such as create a new file, opening existing documents, save and save as.|
|Perspectives Toolbar||Switch between the different perspectives. |
|Sub-toolbar||Provides buttons for quick access to common actions specific to the transformation or job such as Run, Preview, and Debug.|
|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.
|Canvas||Main design area for building transformations and jobs describing the ETL activities you want to perform|
|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|
|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|
|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|
|Hide execution results pane|