Monitors a database using ODBC. The test verifies that the ODBC data source can be opened and accessed. The monitor can also execute a SQL query and compare the result to a predefined value.
System type: All
Category: Database
Database monitor property page
Monitor specific properties
Datasource name - Name of the ODBC data source to be used to connect to the database. This data source must be of the system type.
Username/Password - Optional credentials.
SQL query - Optional SQL query to perform.
No rows fail - Check this option to make the monitor fail the test if the query returns no rows.
Compare value - Value to compare queried result with.
Value type - Type of value that the value queried from the database are compared with.
Operation - Specify how the queried value and the compare value should relate to each other for a successful test.
