Configuring Your Database Before Using Database Monitors
This guide explains how to set up required components for each of the database types supported, in order to use Database Monitors.
In Clarify, the Database Monitor object allows you to execute processes and tasks when certain activity on an external database occurs; this may include inserts, deletes, or updates to database tables and rows. Before using this object however, several components must be set-up on the actual database being monitored. Once setup is complete, a Database Monitor can be deployed and started from the Admin Console. Starting a database monitor will apply a trigger to the specified database table. Once an insert, delete, or update occurs, the Event specified by the Database Monitor will be triggered, and its associated Business Process executed.
This guide explains how to set up the components needed for each of the database types supported, which include:
Prerequisites
- You must have DBA-level privileges.
- You must be able to activate triggers on your database.
- The Stored Procedure installed on the database must have the ability to initiate Web Services requests.
- Permission settings must allow communication between the database components and Clarify.
Database | Supported version |
---|---|
Oracle® |
The following Oracle versions are supported:
|
Microsoft SQL Server® | The following SQL Server versions are supported:
|
IBM DB2® |
This feature supports IBM DB2 for i on the latest i/OS versions. |
For More Information
For up-to-date information on supported versions, please please contact your Customer Account Manager or Cleo Support.