Share:

A Data Compare Test Plan allows you to group Query Compare Test Cases, Component Test Cases and Data Profile Test Cases together and executes all of them in parallel. Data Compare Test Plan can also be kicked off by a File Watcher.

You can also specify how many test cases to run in parallel. A Data Compare Test Plan can be run instantly for once or scheduled to run recurringly at regular time intervals. 

When a test plan is run, the run history details for the test plan and the test cases are saved. The test results are saved at test plan level, test case level, and component level.


Create a Data Compare Test Case

There are several methods to launch the Data Compare Test Case in ETL Validator.

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

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

Open/Edit a Data Profile Test Case

To open/edit a Data Compare Test Plan,

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

Start 

In the Start page, you will enter test plan basic details like name and description.

This page contains the following:

TEST PLAN NAME

Enter a name for the Data Compare Test Plan.

DESCRIPTION

Enter a description for the Data Compare Test Plan.

Label

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

Test Case

In the second page, you select test cases to run in the Data Compare Test Plan. When you navigate to this page, the Test Cases tree is available on the left-hand side, with test folders displayed. Expand the test folder containing the test case you wish to run as part of this test plan, drag and drop the test cases into the Selected Test Cases box on the right-hand side.

Run

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

The Run page contains the following:

Options

  • Parallel Test Cases. Specify the count of test cases to run in parallel.
  • Callback Url. Select an URL that will call the external process after the test plan is executed.
  • Environment. Selecting an environment runs all your test cases against the database in that environment.

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.

Remove

Allows you to remove the selected test plan run.

Remove All

Allows you to remove the complete test plan run history.

Parameters

Allows you to insert parameters.

Refresh

Allows you to refresh the Run page.

Baseline

In the Baseline page, you will baseline test cases.

This page contains the following:

Baseline

Allows you to baseline test cases.

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 Baseline page.

Reports

In the Reports page, you can view the run history of test cases included as part of the Data Compare Test Plan.

This page contains the following:

Export

Allows you to export the test case results by right-clicking in the grid and selecting Export.

Test Run Time Stamp

Allows you to select the specific run history of the test case.

Test Case

These are test cases that were included in the Data Compare Test Plan. Select a test case to see the result.

PreviousNext

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