Alerting functionality

As part of the integration, our Collibra Connect template will provide Pandora with the functionality necessary to alert key users who are in Pandora. In addition to setting up JDBC above, you will need to do the following in order to enable this alert functionality, which will alert Pandora users when a new business rule is added in Collibra for their review. The following steps below will show you how to set this functionality up in your instance of Pandora.

Step one: Create an Alerts table in your database.

The first thing that will be necessary for you to do is to create an ALERTS table in your database of choice. See the pre made sql for help.

Step two: Create a connection in Pandora.

After you've created your table, you will want to create a new Connection in Pandora. To do this, go onto the main screen, right click Connections and select New. Below should be what you see.

Fill out the form with the appropriate items or choose a pre-built Adapter from the drop-down menu.

Step three: Setup your connection

Once you have a new connection you will want to Schedule Load.

To do this, right click on the connection you want to Schedule Load for and select Schedule Load.

Check the box for Schedule Load? as well as Only reload when schedule definition file has changed. In addition to this, be sure to note what the Schedule Definition File is (you can find this file in C:\pandora\imports, by default) as you will need it for the next portion.

Step four: Setup alerts for the ALERTS table.

Once you click Save, you will have all of your tables in your newly added Database loaded, including your ALERTS table. From the home screen select Data and then Tables. Finally, right click on your Alerts table and select edit -> settings.

Select the Alerts tab.

Uncheck Inherited and set the Roster and Priority according to your business needs. Change the Event Type from Red Status to New Version by selecting New Version in the left column. Finally, select Template and then Create New... in order to create a template format that corresponds with your business needs.

Step five: Setting up the Alert Template

Fill it out specifying a Name, Description and Title. Keep the Event Source as the default, as Table. Specify your information and then hit Save. Once that's closed right click Rosters and hit New. You will now see Create Alert Roster (new)

In accordance to your own business needs you should configure who and when should be notified.

Step six: Settings things up in Collibra Connect

In Collibra you will need to setup the appropriate workflow in order to enable writing to an ALERTS table, which will then trigger the appropriate alert in Pandora.

Configuration Options

Configuration Name	Configuration Value	Description	Example
Database URL		Connection URL for Database	jdbc:postgresql://localhost:1234/test?user=test&password=test
Driver Class Name		Driver Class	org.postgresql.Driver

Keep in mind that for your Driver Class, if you need a custom JAR you will have to add it to your build path (see below).

Configuring the trigger XML file.

Configuration Name	Description	Example
Path	The directory associated with the trigger file	C:\pandora\import (default)
File Name/Pattern	The file name that's associated with the trigger file	TEST_VOYA_trigger.xml

In order for the Pandora Alerts workflow to work properly, you will need to specify the xml trigger file associated with the appropriate Connection in Pandora. See above [add reference] for details.

Adding a custom JAR to your build path.

To add a custom JAR to your project's build path you will have to do the following steps.

Once CollibraConnect/ Anypoint Studio is open, you will need to right click on your Mulesoft Project, go to Build Path and select Configure Build Path.

Add an external JAR file.

Once you see the menu open, select Libraries and finally, Add External JARs.... Here you will be able to add the JAR file necessary for Anypoint Studio to connect to your database of choice through JDBC.