Preview: Data Integrity Agent

The Data Integrity Agent is a preview feature that you can try out. Since this feature requires further development, Tricentis can't guarantee full functionality or usability at this stage.

The Tosca Data Integrity Agent allows you to run data comparisons on a local or remote system. This means that you can install Tosca Commander locally and use the lightweight Data Integrity Agent to run your comparisons on a remote system, such as a cloud platform. Running the comparison close to where the data is stored makes it faster, because less data is transferred.

Licensing

The Tosca Data Integrity Agent requires a DI Designer license or DI Execution Only license depending on how you trigger your tests. For further information on licenses, contact your Tricentis sales person.

When should you use the Data Integrity Agent?

Your testing environment determines whether you should use the Tosca Data Integrity Agent or the Tosca Data Integrity Executor to run your tests:

  • If you use JDBC drivers and want to run your tests remote on Windows or Linux, use the Tosca Data Integrity Agent.

  • If you use ODBC drivers, run on Windows, and want to execute on the same machine on which Tosca Commander is installed, use the Tosca Data Integrity Executor.

Run your tests with the Data Integrity Agent

All Modules that you need to run your tests with the Data Integrity Agent are included in the installation package.

You can download the installation package from the Tricentis Support Portal as described in chapter "Install the Data Integrity Agent".

Run row-by-row comparisons with the agent

With the Preview: Complete Row by Row Comparison (DI Agent) Module, you can run your Reconciliation tests on an agent that is installed either locally or on a remote computer.

It offers the same functionality as the Row by Row Comparison Module, however, it supports only JDBC connections and runs on Windows as well as Linux systems.

Test your database with the agent

With the Preview: DB Expert module (DI Agent), you can test your database on a local or remote agent. Like the DI DB Expert Module, you can use it to handle database statements and verify the SQL result set. However, it supports only JDBC connections and runs on Windows as well as Linux systems.

Use additional features of the agent

Like the Tosca Data Integrity Executor, the Data Integrity Agent logs all information about your Data Integrity tests. You can check the logs to analyze your testing activities.

The Data Integrity Agent also creates full error reports of your comparisons. You can define error report settings and how Tosca Data Integrity should handle mismatches as described in chapter "Error Reporting".

Additionally, you can run multiple Data Integrity Agents on a single machine. Each agent creates log files and error reports and stores them in a separate folder.

Get started

To use the Tosca Data Integrity Agent for your tests, you first have to install and configure it.