Share:

A Data Rules Test Plan allows you to define data rules on the source or target database and then checks for data consistency, accuracy and integrity problems. 

As this test plan creates rules for connection at the Data Model, it displays and executes all rules defined for selected tables irrespective of whether the rules were created as part of the test plan. Data rules can be defined at column level using a custom query (using query builder), or custom SQL (enter the query manually).

Some of the example validations are:

  • Verify that the values in column conform to an encoded list.
  • Verify whether the data in a particular column is within expected limits or format.

Data Rules Test Plan can be scheduled or executed on demand. User can also specify options such as number of rules that can be executed in parallel.  The Run History details the Test Plan execution information. Further, reports are available to show data rule success or failure by table and run.


Create a Data Rules Test Plan

There are several methods to launch the Data Rules Test Plan in the ETL Validator.

Depending on your convenience, select any one of the following methods:

  • Method 1
    Mouse hover over the plus icon and select Data Rules Test Plan.
  • Method 2
  1. On the side menu, click TEST PLANS.
  2. Click Tests +.
  3. Under Data Quality Tests, select Data Rules Test Plan.
  • Method 3
  1. On the side menu, click HOME.
  2. Under Common Tasks, Click Create Tests.
  3. Under Data Quality Tests, select Data Rules Test Plan.

Open/Edit a Data Rules Test Plan

To open/edit a Data Rules Test Plan,

  1. On the side menu, click TEST PLANS.
  2. In the Test Plans tree, select the Data Rules folder.
  3. Click on the name of the Data Rules Test Plan.
Information You can also open a test case from the TEST RUNS view.

Data Rules Test Plan Details

When you want to create or edit a Data Rules Test Plan, complete the information in the following pages.

Start

In the Start page,  you will enter basic details like name and database.

This page contains the following: 

TEST PLAN NAME

Enter a name for the Data Rules Test Plan.

DATABASE CONNECTION

Select the database connection from the drop-down list.

DESCRIPTION

Enter a description for the Data Rules Test Plan.

LABEL

Create a label for easy identification of test plan. To create a lable, click the Click to add label link, enter the string, and press Enter.

Save

Allows you to save the changes.

Data Rules

In the Data Rules page, you add a rule.

This page contains the following:

Switch to Grid View / Tree View

Allows you to switch the page display from tree to grid view and vice-versa.

Data Rules

Add a data rule for attributes. To add a rule, select a column on the left, click Add New Rule, and select a condition. Depending on the condition selected, you may have to enter a value.

Other alternate methods available to add a rule are as follows:

Data Rules Wizard

Allows you to open a wizard where you can create a data rule.

Steps to create a rule

  1. In the Select Rule Type page, select RULE GROUP, RULE, and Schema.
  2. Select the column in the table, select the condition type, and enter a value if required. And, select what to consider (error or warning) for success and failure of a query.
  3. Click Create Data Rules.
  4. Click Back to Test Plan.

View/Update Data Model

Allows you to open the Data Model Editor, where can view or update the tables in a data model.

Run

In the final Run page, you will run the test plan immediately or schedule it to run the test plan later.

The Run page contains the following:

Options

  • Select Tables. Select the tables to apply the data rules
  • Parallel Rules. Select how many data rules to apply in parallel while running the Data Rules Test Plan.
  • Callback URL. Select an URL that will call the external process after the test plan is executed. 

Run

Allows you to run the test plan.

Schedule

Allow you to create a schedule to run the test plan at recurring time intervals.

Notify

Allows you to add recipients for sending email notifications about test plan run details.

Run Date

Allows you to select the test plan run history.

Remove

Allows you to remove the selected test plan run.

Remove All

Allows you to remove the complete test plan run history

Refresh

Allows you to refresh the Run page.

View Report in Browser

Opens the Data Rules Test Plan results in ETL Reporting.

Export to Excel

Allows you to export the results in Excel format.

Information The records are shown for Data Rules with failure status only

PreviousNext

© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support