Create your own TestCase templates

TestCase templates form the basis of your Tosca BI tests. When you run a Tosca BI Wizard, the Wizard uses a template to create your TestCase.

If you do not want to use one of the TestCase templates provided in the Tosca BI Modules And Samples.tsu subset, you can create your own.

To do so, follow the steps below:

Create a new TestCases folder in the _Tosca BI Templates folder.
In this folder, create a new TestCase.

Create a new TestCase

To create TestSteps, drag and drop an appropriate Module onto the TestCase.

For example, to create a TestCase template for Field Tests: Database to Database, you can use the BI DB Expert Module from the Tosca BI Modules And Samples.tsu subset.

Drag and drop it onto the TestCase twice: Once for the source and once for the target.

Drag and drop the Module onto the TestCase to create a TestStep

Rename the newly created TestSteps.
Connect to the source and target of your data: Specify one of the connections you have defined in the Connection Manager for each TestStep.

To do so, click into the Value field and select a connection from the drop-down menu. Note that you can't override the specified connection with dynamic expressions such as buffers or test configuration parameters.

Example TestCase with Sample connection 1 as source and target

In each TestStep, enter an appropriate value for SQL Statement. Check the sample TestSheets in the _Tosca BI Samples Tests and Execution Lists folder for information on available attributes for XL paths.

For example, refer to the sample TestSheet Field tests for comparing tables to see which attributes you can use for Field Tests: Database to Database tests.

Sample TestSheet: Attributes - TestStep: SQL Statement

Fill out any additional TestStepValues that you need to run tests with this template.

For example, in a Database To Database field test, you may want to get one or more values from the source database and compare it to the target database. Modify your TestSteps accordingly:

Example TestStepValues for Field tests

Specify the required template properties for your TestCase.

Properties of a Field Tests: Database to Database TestStep

Right-click the TestCase and select Convert to Template from the context menu.
If you are creating a template for Pre-Screening: File or Vital Checks: Database to Database tests, add the condition 'Status' != 'Deleted' to your TestCase template.

This condition ensures that if you later update your TestCases with the Update Wizard, the Update Wizard does not create TestCase instances for deleted TestSheet instances.

To do so, add the column Condition via Column Chooser and type in the condition.

Example condition for a Vital Checks TestCase template

You can now run the Wizard and create your TestCases. To do so, create a new BI folder and run the respective Wizard on this folder.

Create a BI folder

In the Wizard, select the test you have created.

In this example for a Database To Database field test, you can select the test created with the TestCase template in Step 4 - Select Field Tests.

Select your test in Step 4 - Select Field Tests

Set required TestCase template properties

Which properties to set in your TestCase template depends on the type of test you want to run with it.

To set a property for your TestCase template, follow the steps below:

Expand the Properties pane by clicking theProperties icon in the top right corner of your workspace window.
Fill out the properties as described in the chapters below.

Properties for Pre-Screening tests

If you create a template for Pre-Screening tests, set the following properties:

Property	Value
BITestDirection	FileOnly
BITemplate	True
BITemplateType	Prescreening

Properties for Field Tests: Single Database tests

If you create a template for Field Tests tests, set the following properties:

Property	Value
BITestDirection	SingleDatabase
BITemplate	True
BITemplateType	Field

Properties for Field Tests: Database to Database tests

If you create a template for Field Tests tests, set the following properties:

Property	Value
BITestDirection	DatabaseToDatabase
BITemplate	True
BITemplateType	Field

Properties for Vital Checks: File to Database tests

If you create a template for Vital Checks: File to Database tests, set the following properties:

Property	Value
BITestDirection	The value depends on what you want to test: Templates for file field tests need the value FileOnly. Templates for Completeness or Metadata tests need the value FileToDatabase.
BITemplate	True
BITemplateType	Set the Value according to the test you would like to run with this template: Prescreening for your file tests Completeness or Metadata for your database tests

Property

Value

BITestDirection

The value depends on what you want to test:

Templates for file field tests need the value FileOnly.
Templates for Completeness or Metadata tests need the value FileToDatabase.

BITemplate

True

BITemplateType

Set the Value according to the test you would like to run with this template:

Prescreening for your file tests
Completeness or Metadata for your database tests

Properties for Vital Checks: Database to Database tests