Looking for the previous version? View v2024.06 documentation →
Business Rule Validation of RDBMS Table
Overview
This guide demonstrates Business Rule Validation applied directly to an RDBMS table. A validation scenario is configured to fetch data from a relational database and evaluate it against one or more business rules such as Null Check, Range Check, or Pattern Check.
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 target table is accessible.
Steps
Path: Data Trust › Scenario Studio › Scenario Builder › Business Rule Validation of RDBMS Table
Navigate to the Scenario Studio module and select the Business Rule Validation of RDBMS Table 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.
This step involves interacting with the Available Data Sources within the Business Rule Validation of RDBMS Table workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.
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.
The RDBMS Widget 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 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.
The All fields in Additional Settings Button 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.
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.
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.
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.
This step involves clicking the Click on Select Button within the Business Rule Validation of RDBMS Table workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.
The Transformations tab lists all available data transformation widgets including Filter, Derive, Aggregate, and Lookup. Add transformation widgets between data source and reconciliation or validation widgets to cleanse or reshape data before comparison.
The Transformations tab lists all available data transformation widgets including Filter, Derive, Aggregate, and Lookup. Add transformation widgets between data source and reconciliation or validation widgets to cleanse or reshape data before comparison.
Drag the Filter Transformation 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.
The Filter Widget 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 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.
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.
This step involves interacting with the All availabel rules within the Business Rule Validation of RDBMS Table workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.
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.
The All Fields in the Duplicate Check rule 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.
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.
The Additional Settings panel provides advanced configuration options such as custom SQL filters, join conditions, and performance tuning parameters. Configure only the settings relevant to your scenario — leave optional fields at their default values unless a specific behaviour is required.
Navigate to the Scenario Studio module and select the Business Rule Validation of RDBMS Table 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.
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.
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.
This step involves interacting with the All Action Buttons within the Business Rule Validation of RDBMS Table workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.
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.
The Validation Execution Summary Page page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.