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

These conditions must be met before setup and integration with Database Monitors can occur.
  1. You must have DBA-level privileges.
  2. You must be able to activate triggers on your database.
  3. The Stored Procedure installed on the database must have the ability to initiate Web Services requests.
  4. Permission settings must allow communication between the database components and Clarify.
Table 1. Supported Database Versions
Database Supported version
Oracle®

The following Oracle versions are supported:

  • Oracle 11.2 (11i\11g)
  • ‏‎Oracle 12.1 (12c)
    Note: Express editions are not supported.
Microsoft SQL Server® The following SQL Server versions are supported:
  • 2008
  • 2012
  • 2014
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.