Composite DataSource
Composite datasource is a datasource that allows you to design a data flow using various data manipulation components in a network to get a personalised view of the data.
To use the DataSource Wizard, right-click on the folder where the composite datasource is to be created. The list of available actions will appear. Select the “Add” option, then the “Datasource” from the sub-options that appear.
The DataSource Wizard will appear. For composite datasource, there are three steps:
- Select datasource type
- Define datasource details
- Define security option
Select Datasource Type
In the DataSource Wizard, select “Composite” from the list of available options, then click on the “Next” button.
Define Composite Datasource
In this second page, the details of the composite datasource need to be defined.
| Field | Description | Mandatory |
|---|---|---|
| Name | Name of composite datasource. | Yes |
| Description | Brief description of composite datasource. | No |
The mandatory fields must be filled, else an error message will appear in the page with a red dot and the “Next” button will not be enabled.
Fill in the fields as required and click on the “Next” button. Alternatively, if you wish to use the default security options, click on the “Finish” button to complete the process.
Security Option
The last page in the wizard for the composite datasource allows you to set the security options for the datasource.
There are three options.
| Type | Description |
|---|---|
| Read Only | When selected and saved, the next time a user opens this datasource, the user will not be able to edit any details of the datasource (such as name, description and column names). |
| Hide Details | When selected and saved, the next time when this datasource is opened, the user will only be able to see the name and description of the datasource. |
| Encrypted | This is to be used with either Read Only or Hide Details options or both. Checking the checkbox will prompt the user to enter a password, then re-enter to confirm the password (both password must be the same). After this is done, if another user would like to edit any selections, he will need to enter the password. |
By default, none of the options are selected. Select the options are desired. More than one option can be selected. If “Encrypted” is selected, provide a password in the pop-up dialog box. Click on the “Finish” button to complete the process.
The new datasource will appear in the repository on the left and opened in the workspace. Below is an example of a composite diagram.
You can edit the diagram using the processors on the menu bar. See Data Operation Processors for more details.