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:
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.