Preview: DB Expert module (DI Agent)

The Preview: DB Expert module (DI Agent) is a preview Module that you can try out. Since this Module is under development, Tricentis can't guarantee full functionality or usability at this stage.

With the Preview: DB Expert module (DI Agent), you can test your database on an agent that is installed either locally or on a remote computer. It allows you to handle SQL statements and to verify or buffer the SQL result set.

Download the Module

The DB Expert module (DI Agent) is included in the Tosca Data Integrity Agent installation package that you can download from the Tricentis Support Portal. For more information, see chapter "Install the Data Integrity Agent".

Use the DB Expert module (DI Agent)

The DB Expert module (DI Agent) contains the following ModuleAttributes:

ModuleAttribute

Description

Agent

Specify the address of the machine where the Data Integrity Agent runs.

Use localhost, the name of the remote computer, or an IP address.

By default, the agent communicates on HTTP port 80 and HTTPS port 443. If you have specified your own port, add it after the agent name separated by colon.

Examples: localhost, RemoteComputerName:1234, 1.2.3.4:1234, localhost:1234

JDBC - Connection String

Enter the Java Database Connectivity (JDBC) connection string to access the database.

Example: jdbc:sqlserver://1.2.3.4:49789;instanceName=SampleInstance;databaseName=TestDB;user=myUser;password=myPassword

JDBC - Class Name

Enter the name of the class in the JDBC driver.

Example: com.mysql.jdbc.Driver

SQL Statement

Specify the SQL statement that you want to execute.

Optionally, you can use the SQL Editor to help you create SQL statements.

Result Table

Verify or buffer values from the result of your SQL statement. For more information on how to use ActionModes to steer tables, see chapter "Table".

Optionally, you can export the result of your SQL statement into a comma separated file.

Note that the result set is read-only. This means that you can verify or buffer, but you can't change it.

In this example, you want to query a data source and verify a value in this data source. To do so, you add the following TestStepValues:

  • You specify the Address of the machine on which the agent runs.

  • You specify the JDBC Connection String and Class Name to connect to the data source.

  • You add an SQL statement that queries the data source and retrieves all data from the table Customers.

  • You specify that the Result Table should be exported into the file Customers.csv located at C:\Temp.

  • You specify row, cell, and cell value to verify whether the last cell in the first row of the table contains the value Berlin.

  • You use the ActionMode Verify to verify the SQL result set.

Preview: DB Expert module (DI Agent) in a TestCase

Run your test

Once you've added your TestStepValues, you are ready to run your tests.

By default, the Tosca Data Integrity Agent closes the connection after executing the SQL statement.