Real-Time Lotus Notes & RDBMS Integration

To transfer Lotus Notes data the built-in @formulas are used, which are well known by any Lotus developer or administrator. For each form, user can define 3 @formulas for each of the events INSERT/UPDATE/DELETE. These formulas in fact define a SQL query, which will be executed when processing corresponding event for a particular document.

A monitoring module, which is implemented as Lotus Domino database hook add-in, triggers data transfer as soon as a document is changed in Lotus Notes.

Lotus Notes database is used to store the information about modified Lotus Notes documents, which is, in fact a persistent queue. This eliminates the risk to miss any document changes, for example, during SQL server downtime, which potentially may cause Lotus Notes and SQL databases to be not in sync.

It is executed as the Domino server task and provides timely transfer of data for documents, which were put in the queue by the monitoring module:

• Insertion or updating of any number of table rows, both for single-value fields, and multi-value fields
• Deletion of table rows
• Creation, modification and deletion of SQL database tables
• Execution of stored procedures on the SQL server
• What’s important is that all operations are executed in the single transaction.

The speed of data transfer on a typical configurations of Lotus Domino and SQL reaches dozens thousands operations per minute. This speed is achieved by using Lotus C API when accessing Lotus Notes data.