Creating a New Data Set using RDBMS Connector

Check out the given walk-through on how to create a Data Set using the RDBMS Data Connector.

Data Set Creation

• Navigate to the Data Center homepage.

• Click the New option.

• Select the Data Set option from the context menu.

• The Data Source page opens.

• The Data Connectors list gets displayed.

• Search for a Data Connector using the Search Data Connectors bar.

• with the Create Data Set Action icon (+) for all the available data connectors.

• The Data Set page opens.

• Service Name: Enter any user-defined name for the new data set.

• Description: Provide a brief description of the Data Set (optional).

• Data Connector Name: This is a pre-defined field based on the selected data connector.

• Database Name: This is a pre-defined field based on the data connector chosen earlier.

• Query: Write a valid query service in the given space (Use Ctrl+ Space keys for assistance in writing a query).

• Table Information: On the right side of the page Table information is displayed and that will contain all the tables in the Data base and the Column name in the table. Double click in the Table or Column will auto generate a sample query so that user can validate and get data.

• Click the Validate option to execute the new Data Set.

• A notification message appears to inform the successful execution.

• The Data Preview appears at the bottom of the page.

• The Save option gets enabled. Click it.

• A notification message appears to assure completion of the action.

• The newly created Data Set gets added to the Data Sets List.

​

Please Note: The Publish iconbeside a Data Set name suggests that the data set has been published.

​​	Edit/View	Opens the Data Set form in the editable mode for the user to edit or view the Data Set fields.
	Share	Shares the Data Set to the selected user(s) or group(s) or to exclude the selected user(s)/user group(s) from the rights to see a Data Set.
​​	Publish	Publishes the selected Data Set.
​​	Push to VCS	User can push different versions of the same data set, this can be downloaded and replaced with the existing Data Set for the future use, if required.
	Pull from VCS	This is to pull a specific version of the Data Set from the version control system.
​​	Delete	Removes the selected Data Set from the list
	Data Preparation	Opens the data from the selected Data Set in the Data Preparation framework.
	Visualize	Redirects the user to create a Widget

Please Note: At present the Edit, Publish, and Deleted icons are provided under the More Actions icon.

Applying Dynamic Filter in an RDBMS Data Set

The user can insert dynamic filter conditions via the query service to an RDBMS Data Set.

• Navigate to the Data Set form for any RDBMS connector.

• Enter the filter condition to the Query section. Use the @text@ syntax inside the query to define the filter.

• Click the Validate option.

• Right side dialog window opens, asking for the filter value.

• Enter a filter value.

• Click the Continue option.

• A notification message appears.

• The data preview of the filter data displays at the bottom of the page.

• Click the Save option to save the Data Set form.

• A notification message appears to inform the users that the Dataset has been created.

• The newly created dataset gets saved with the filter value under the Data Sets list.

Please Note:

• Use the CTRL+ Space keys to get assistance while writing a query.

• Click the ‘Help Center’ iconfrom the Data Set form to get rules regarding the formation of a query. The query formation rules get displayed in a new pop-up screen.

​

• The user can customize the Data Sets list by Data Connector Type, Data Connector, and Publish Status. These customization options are provided on the top of the Data Sets List page.

DATA Protection

In data set validation page there is one more option is available for Data protection, This will provide different type of security for the Data we are providing.

Rule Types

• Redaction

  • Full/ Partial reduction is available

  • Redaction Type/Mask Type partial option user can decide the length and the starting point

• Masking

  • User can apply the masking and decide the length and starting point for masking

  • The Masking character can be decided.

• Hashing

  • Three types of Hashing is available

    • SHA 25

    • SHA 384

    • SHA 512

​​

• Date Generalization

  • Year, Month, Quarter, Week Options are available for data generalization.

​​

• Appy Data protection :

Restricting Displayed Data for End Users via Data Set

BDB Platform provides an option to control data display for the Dashboard end-users.Please Note: Data Restriction through Data Service (Data Set) is interconnected with multiple platform plugins. The precondition for this feature is that the users should possess a good understanding of all the involved BDB Platform modules and the Dashboard Designer plugin.

• Create a Custom Field using the Configuration and settings admin section.

• Create a Data Set using the ENV with the selected Custom Field Key.​

• Create a Dashboard using the Data Set.

• Publish the Dashboard to the portal.

• Open the Dashboard (it opens in preview mode by default as displayed below).

• Create a new user (using the Security module) and pass the Custom Field value/ Update an existing user passing the Custom Field Value.

• Share it to another Platform user via the Share with User option.

​

• Access the dashboard from the updated user’s account to whom it was shared.

• Open the shared dashboard; the dashboard displays only permitted data by the admin.