Data Flow Tab

You can use this tab to design and maintain flows in a data job. The tab includes the following elements:

Resource Pane - Displays the resources that you can add to the Data Flow Editor. The following display shows a Resource pane with an open Nodes riser bar:

The Resource Pane includes the following elements:

• Nodes Riser Bar - Displays the nodes that you can add to the Data Flow Editor. The toolbar above the riser bar enables you to insert a selected node and insert selected nodes before or after nodes that you select in the Data Flow Editor. For an overview of all data job nodes, see Data Job Nodes.
• Folders Riser Bar - Displays repositories. You can add items from the repositories to the Data Flow Editor. The toolbar above the Folder Riser Bar enables you to group items by type, find items, find in folders, and insert a selected item.
• Accelerators Riser Bar - Displays any DataFlux accelerators that have been installed.
• Selected Node Pane - Displays the name of the node that is selected in the Data Flow Editor

Data Flow Editor - Hosts the data flow, as shown in the following display:

You can drop nodes into the Data Flow Editor and manipulate them as needed. The toolbar above the editor provides the following controls:

• Action Menu - Enables you to access utility functions that affect data flows and data flow nodes.
• Open Node - Opens a selected node.
• Edit - Opens a selected node for editing.
• Insert New Note - Adds a note to the Data Flow Editor.
• Run Process Job - Runs the process job that contains the Data Job node and its Data Job tab; displayed only for Data Job nodes contained in process jobs
• Run Data Job - Submits the job contained in the Data Flow Editor for processing.
• Clear Node Status Indicators - Clears the node status indicator from one or more selected nodes.
• Clear All Run Results - Clears all results from a process job run.
• Preview - Initiates a preview run of a selected node. You should consider previewing the nodes in a data job to ensure that will get the results that you expect when you run the job. You can preview a node by selecting it and clicking the Preview tab. Note that the data viewer in preview displays might display fewer rows than you need to see. If you need to see more rows, open the Tools menu and click Data Management Studio Options. Then, click DataViewer and enter an appropriate value in the Number of rows to show in the preview pane field. Finally, you can quickly review the output of a table in a data job by previewing it after the run is successfully completed.
• Layout - Toggles between Left To Right and Top To Bottom layouts
• Zoom - Zooms into and out of the Data Flow Editor.
• Reset Zoom - Resets the Data Flow Editor to the default level.

Overview Window - Displays an overview window of the full data flow, as shown in the following display:

You can grab and drag the window to focus on particular segments of the flow. Click the window to reduce or expand it.