Using the SQL Query Wizard

The SQL Query wizard uses a Structured Query Language (SQL) statement or Stored Procedure to query information from a Microsoft® Open Database Connectivity (ODBC) Data Source. The SQL Query wizard enables you to create one or more Tests in a Reveille Monitor.

ODBC is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs, and uses SQL as its database access language.  ODBC was created to provide a uniform method of access to different (for example, heterogeneous) database management systems (DBMSs).

SQL is a text-based language enabling users to query, update, and manage data in relational databases. A SQL statement is a complete phrase in SQL beginning with a keyword and completely describing an action to be taken. For example, SELECT * FROM Orders.  The SQL Query wizard helps you build an SQL statement, and then enables you to create a Test based on the results of executing the SQL statement against your Data Source. The Reveille Test passes if the number of records returned by your SQL statement matches the Test condition.

The SQL Query wizard also enables you to create a Test based on the results of executing a stored procedure. A stored procedure is a group of one or more pre-compiled SQL statements stored as a named object in a database.  

The SQL Query wizard lets you select an existing stored procedure, and then lets you create a Test based on the results of executing the stored procedure against your data source. The Test passes if the returned value or specific column of the stored procedure matches your Test condition.

The SQL Query wizard defines the following Test types:

• SQL Statement Test
• Stored Procedure Test