Next Topic

Previous Topic

Book Contents

Database server

Monitor description

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.