Ask the Expert

DECS to monitor the back-end database?

Can you set up a DECS connection and populate the keys Domino can retrieve, update, delete and add records to. (We have many DBS succesfully in production: db/2 db/400 Oracle, MS-SQL, MS-Access etc.) However, when a record is created in the backend, Domino is unaware of it. Is there a way with DECS to do so? What would be the alternatives?
There is no way for DECS to monitor the back-end database for [external] inserts or changes - in R5*. You can definitely use LEI with a Polling Activity to watch for a trigger. When the trigger statement becomes true, i.e. a new row is inserted, the Polling Activity can launch another activity, such as a Replication from the back-end to Notes. *New features of D6 used in conjuction with LEInext will do this for you. Search in here for LEInext ---> http://www-10.lotus.com/ldd/nfr6forum.nsf?OpenDatabase.

This was first published in August 2002