Martin Perrie 17.Apr.07 03:10 PM a Web browser LEI LEI - All Releases AIX
I think I'm having a bit of a brain storm and this is probably a really dumb question. Apologies in advance.
LEI primary key replication activity will pick up data from a Notes database and push it to a SQL Server database. The Notes database is on a different Domino server to LEI. The SQL Server is behind a firewall, which needs opening up to allow the LEI activity to write the data. Am I correct in thinking that it's the LEI server that requires access through the firewall (not the other Domino server)?
As a further point there will be a second replication activity operating in the opposite direction. However there is no data as such that needs to be pushed from SQL to Notes. When a status field on SQL is set to 'completed' some fields on Notes need updating to either a fixed value or current date / time. My thought was to set these fields on the Data Transformation tab ( formula to execute prior to update) and to only define the key field in the fields list on the activity.
Is this the best way to do this or are there any better ideas?