> > > Creating Database Monitors

Creating Database Monitors

31st January 2020

Background

Sometimes Cleo Clarify users want to process database data as soon as it populates in a table or there is a change in a field.  By implementing Cleo Clarify Database Monitors, users have the ability to implement this functionality.

Setup – Create Event

In Cleo Clarify create an Event.

With the Clarify Event, we will attach it to the Database Monitor and call the correct Outbound Launcher Business Process (below).

image

Setup – Create Database Monitor

Once the Clarify event is created, we will create the Clarify Database Monitor (below).

In our example/scenario, we are monitoring a trigger file.  The trigger file is populated, by a back-end process, when all the necessary data is present in the related tables.

Some values will need to be filled in here for the correct triggers.

Creation of Database Monitor

1. Identify the Database Data Source


2. Attach recently created Clarify Event.


3. Determine database Table the monitor will watch.


4. This example is triggering on the creation of when new records are created where HEANCB = IPC and HEALCB = 315


5. Select the columns to return.


6. Populate SQL statement – HEANCB = IPC and HEALCB = 315

image

Setup – Deploy Objects to Server

Once the Clarify Event and Clarify Database Monitor are created, we want to deploy the objects to the Cleo Clarify Server.  

After the deployment is performed, select the Resource Monitors tab in the Admin Console and start the Database Monitor (below).

image

Final Result

Now, whenever a new record with the specified criteria populates this database table. The Outbound Launch Business Process will launch automatically.


By: on