Row by Row Comparison Module

You can use the Row by Row Comparison Module to execute Reconciliation tests.

It is included in the Tosca DI Modules And Samples.tsu subset and located in the folder Modules -> Data Integrity Testing.

For information on how to use the Row by Row Comparison Module for Reconciliation tests, see chapter "Run Reconciliation tests manually".

If you run a 64-bit operating system, you can use both 32-bit and 64-bit ODBC connections.

If you run a 32-bit operating system, you can only use 32-bit ODBC connections.

Specify which Row by Row Comparison Module to use in Reconciliation tests

If you have more than one Row by Row Comparison Module in your workspace, you need to specify which Module should be used for your tests. Otherwise, the system uses the first Module it finds.

This is also true if the Row by Row Comparison Modules have different names, since the system uses the configuration parameter SpecialExecutionTask to check for applicable Modules.

To specify a Module, you need to create a configuration parameter for it: 

  1. Right-click the respective Module and select Create Configuration Param from the mini toolbar.

Create a configuration parameter via the mini toolbar

  1. Name the newly created configuration parameter DIWizardUseInAutocreate.

  2. Set its Value to True.

You can switch Modules between tests by deleting the configuration parameter from one Module and adding it to another.

Make sure that only one Row by Row Comparison Module at a time has the DIWizardUseInAutocreate value set to True. Otherwise, the system uses the first Module it finds.