The Web UI Flow Editor lets you create and edit data flow diagrams. The dataset node and the operations that can be performed on the dataset can be dragged from the Operations Palette and dropped in the canvas. Connections between the nodes can then be made by gently dragging one node towards the other. Once the data flow diagram is complete, the flow can be published for use in Studio and other applications outside the Web UI.

The Operations Palette displays various operations such as Filter, Join, Union, Except, Intersect. Using drag and drop feature, users can build the data flow diagram on the Canvas.

The Expression Builder lets you manipulate and build the query. Syntax help is provided for every function available in the expression builder.

The Details pane that is displayed below the Canvas provides the user with the list of columns to show/hide, an expression builder to manipulate the data, the result set data with ability to scroll through, and a read-only query view.

Refer to the Chapter Flow Editor for more information.