1

Basic Notifications monitor an operation that happens to a database table, such as an insert, update, or delete operation. You specified the buffer table to monitor at the time you configured the adapter.

2

The notification gets a connection from the service's connection pool.

Adapter connections contain connection information for the database, including JDBC driver parameters.

3

The notification uses the JDBC driver to connect to the database.

You created and enabled the adapter connection earlier using Integration Server Administrator.

4

Unlike Insert Notifications, Update Notifications, and Delete Notifications, you create your own buffer table and trigger, or other means of monitoring database changes. The diagram and steps listed here assume you are creating your own buffer table and trigger to monitor for changes.

The buffer table you define will hold the data selected by any trigger you create. The trigger will monitor the database table and insert data into the buffer table.

5

The notification retrieves the rows of data from the buffer table.

6

The notification creates the publishable document, which contains a row of data from the buffer table. The notification publishes the publishable document.

For more details about the Integration Server publishable documents, see the Publish-Subscribe Developer’s Guide for your release.

7

Using an Integration Server trigger you configured to use the notification's publishable document, a flow or Java service on Integration Server is invoked to react to the data changes contained in the publishable document.

After the data is published, the data in the buffer table will be retained or removed, depending on how you configured your buffer table and trigger.