You are viewing documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Validation Using Natural Language Processing (NLP) Rule

Define validation rules in plain English using the NLP rule type.

Overview

NLP-based Validation Rules allow users to define validation logic using plain English sentences rather than code or formal expressions. Data Trust interprets the natural language input and translates it into executable validation logic.

Note: Ensure all required connection profiles are configured in the Administration module before building this scenario.

Prerequisites

You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
An RDBMS connection profile has been configured and the NLP feature is enabled.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Validation Using Natural Language Processing (NLP) Rule

Click on Menu-Click the Validation

Figure 1: Click on Menu-Click the Validation

Navigate to the Scenario Studio module and select the Validation Using Natural Language Processing (NLP) Rule option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.

Validation scenario page

Figure 2: Validation scenario page

This step involves interacting with the Validation scenario page within the Validation Using Natural Language Processing (NLP) Rule workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Drag and Drop RDBMS widget

Figure 3: Drag and Drop RDBMS widget

Drag the Rdbms Widget from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.

Read data from table popup

Figure 4: Read data from table popup

The Read data from table popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Database type_connection name

Figure 5: Database type_connection name

Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.

Click the Navigator-select on schema and table

Figure 6: Click the Navigator-select on schema and table

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table or view, then click Select to add it to the widget configuration.

Pick the table field on the metadata

Figure 7: Pick the table field on the metadata

Click Get Metadata to automatically retrieve the column structure and data types from the connected data source. Review the retrieved metadata and deselect any columns that are not relevant before proceeding to configure validation rules.

Click on show row count

Figure 8: Click on show row count

This step involves clicking the Click on show row count within the Validation Using Natural Language Processing (NLP) Rule workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Click on preview data

Figure 9: Click on preview data

The Preview Data option fetches a sample of records from the selected table to verify the connection and column structure. Confirm that the correct columns and sample data are visible before closing the preview and saving the widget.

Click the Select button

Figure 10: Click the Select button

This step involves clicking the Click the Select button within the Validation Using Natural Language Processing (NLP) Rule workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Create RDBMS widget

Figure 11: Create RDBMS widget

This step involves interacting with the Create RDBMS widget within the Validation Using Natural Language Processing (NLP) Rule workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Click the Validation Rules tab

Figure 12: Click the Validation Rules tab

The Validation Rules tab lists all available business rule widgets that can be applied to the selected dataset. Drag the required rule widget onto the canvas, configure its threshold or pattern, then save before moving to the next step.

Drag and Drop the NLP widget

Figure 13: Drag and Drop the NLP widget

Drag the The Nlp Widget from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.

NLP rule popup

Figure 14: NLP rule popup

The NLP rule popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Click the Input Data Preview

Figure 15: Click the Input Data Preview

Enter the prompt and click on generate rule

Figure 16: Enter the prompt and click on generate rule

This step involves entering values in the Enter the prompt and click on generate rule within the Validation Using Natural Language Processing (NLP) Rule workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

generated business rule

Figure 17: generated business rule

Click on show sample output and Save

Figure 18: Click on show sample output and Save

Click the Save button to persist the current widget or scenario configuration. A confirmation indicator appears on the canvas once the save is successful, and the widget thumbnail updates to reflect the configured state.

Click the additional options tab

Figure 19: Click the additional options tab

All additional option icons displayed

Figure 20: All additional option icons displayed

Drag and Drop email widget

Figure 21: Drag and Drop email widget

Drag the Email Widget from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.

Email popup

Figure 22: Email popup

The Email popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Select the Email when exceptions

Figure 23: Select the Email when exceptions

The Email widget sends an automated result notification to configured recipients after the scenario finishes executing. Provide the recipient addresses, subject, and choose whether to attach the exception report or include a summary in the email body.

Click the execute now

Figure 24: Click the execute now

Click the Execute button to trigger the scenario and begin processing data from the configured sources. The scenario transitions to Monitor mode where you can track real-time execution progress and view interim results as each step completes.

Click the NLP rule count

Figure 25: Click the NLP rule count

This step involves clicking the Click the NLP rule count within the Validation Using Natural Language Processing (NLP) Rule workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Navigate to validation exceptions

Figure 26: Navigate to validation exceptions