Real-Time Lotus Notes & RDBMS Integration

One of the most actual tasks in the enterprise IT infrastructure is to organize single data access point based on data received from heterogeneous sources: from Lotus Domino documents, relational databases, ERP systems, etc.

More Info

One of the most popular solutions in this case is creation of a common data repository based on some RDBMS. Usually, such repositories are organized using one of the most popular relational databases, like MS SQL, MySQL, Oracle, etc. The main goal of creating such single common storage is ability to create reports, which consolidate data related with different business processes and their phases within the enterprise.

We have created a product for efficient transfer of data from Lotus Notes and Domino into SQL in almost real-time. The product has few advantages compared to its competitors.

Below is the list of main product features:

  • Flexible transfer of data structures of any complexity

    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.

  • Data transfer is performed almost in real-time

    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.

  • Persistent queue

    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.

  • Data transfer module

    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.
  • High data transfer rates

    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.

We will propose the best solution for your business!