Good day to everybody!
Please, help me to answer one question about Lotus Enterprise Integrator.
I installed a small local net for testing the basic features of LEI. The net includes:
1 computer - Lotus Domino 6.5.1, Lotus Enterprise Integrator for Domino 6.5.1, platform Windows 2000 Server SP4.
2 computer – SQL 2000, platform Windows 2000 SP4
there is no firewall or something else security software on these computers.
LEI was installed OK. I created necessary connection documents on Domino Server and made initialize keys operation.
During testing, I have mentioned then following:
- When changes are made in Lotus Notes database:
-
I add new document in Lotus Notes database and it appears in SQL table
-
I change fields in Lotus Notes document and changers go to SQL table
-
I delete Notes document and the record is deleted from SQL table
- When changes are made in SQL table:
-
I add new record to SQL table and no document automatically appears in Lotus Notes. I also can not add new document to Lotus Notes manually because LEI does not allow me to create documents with key fields, which are already used in SQL table (no possible solution has been found)
-
I change fields in SQL table and Lotus Notes fields also change. But in Notes view the old information is displayed (I use special scheduler agent to update all documents in Lotus Notes database)
-
I delete SQL record, but no documents is deleted form Lotus Notes. Information still appears in Notes view. But there are no fields in Notes document (no possible solution has been found)
So I have the following questions:
-
these bugs are the key limits of current release on LEI?
-
I installed and use LEI not the correct way?
-
these bugs appear when non IBM relational database server software (DB2) is used?
I have read all information about LEI on www.notes.net but found no answer. Please, help me to understand LEI.
Best regards
Boris Fedorchuk