Adding a Dataset

A flow is created by adding a dataset to the canvas. In order to add and configure a dataset, follow these steps:

Click on the Dataset icon on the Operations Palette

The “Add dataset” window is displayed. Choose the datasource from the list that is displayed. The list includes existing Flows created using the Web UI along with other published resources. Note that you can choose multiple datasources by using the SHIFT button (to choose a continuous list) or the CTRL button in the keyboard.

Note: You will not be able to select multiple datasources from the Search results when you use search option.

Click the SELECT button to select the datasources into the canvas. If multiple datasources are chosen, multiple datasets will be created on the canvas.

In the canvas, when you choose a dataset,

- All the available columns in the data set are displayed in the Columns tab of the Data Configuration pane.

- The Dataset tab of the Data Configuration pane displays the details of the dataset such as the full path, a description, type and owner of the resource, created/modified date, etc.

- A preview of the dataset is displayed in the Preview Pane. The columns can be sorted by clicking on the column header.

Features and Limitations of the Dataset Operation

•

There are no inputs to the Dataset node/operation.

•

The Dataset node can have only one output.

•

By default, the name of the table/datasource is the name of the dataset node. However, this can be edited by clicking on the name. The path of the datasource is also displayed on the node.

•

There is no limit to the number of datasets defined in a flow. But there must be at least one dataset node defined.

•

To delete a dataset node, hover the mouse on the node and click on the delete icon that is displayed on the top right corner of the node.

Did you find this helpful?

Yes No