How do I monitor database tables using SQL query?

To monitor database tables using SQL query, SQL Query monitor can be used. This article gives you an example of how to deploy an SQL query monitor and create a sensor to monitor the facts generated.

1. Right-click the CEP server on which you want to deploy the SQL Query Monitor.
2. Select Deploy Expert > Probes > SQL Query Monitor.
   
3. On the General tab, enter a name for the SQL Query Monitor being deployed:
   
4. Fill in the Database details on the JDBC Options tab:
5. Specify an SQL query on the SQL Query tab:
   
6. Deploy the SQL Monitor.
7. The Facts are deployed as shown below:
   
8. Create a new business view. Go to the Sensor Wizard and include the facts you want to monitor and add sensor rules.
   
   
9. Open the policy. Go to the properties tab for the sensor and select the Logging tab and add or create the database tables.