Performing a Database Query

The Database Query Monitor executes SQL queries on the most popular database servers currently available on the market (SQL Server, MySQL, Oracle and PostgreSQL) and monitors their return output within your PATROL environment. You can then run string or numeric value searches, or perform value mapping on the return output to monitor the result in myriad ways.

If the technology you wish to monitor uses a database server, you can test this database by sending applicative queries to the database server, or by testing the content of some critical data tables. As query results are stored by Monitoring Studio in a pipe-separated table format, it is easy to search for strings or numeric values and extract these values from a database query result. Refer to the String Search, Numeric Value Extraction and Value Map sections for more information.

Supported databases are: