RE: Best practice integrating Notes and MS SQL Thomas Kennedy 12.Apr.11 12:35 PM Lotus Notes LC LSX All ReleasesAll Platforms
LCLSX is still current and works fine. As our desktops are all Windows we use it with the OLE DB connector. If we were on unix, or if we had server code to run on a unix box the same code would run as-is just using a different connector. If you do not have Lotus Enterprise Integrator I recommend taking a look at that also. It's a form-based tool for replicating data back and forth between Notes, SQL Server, Oracle, flat files and so on. Its integration with Notes is particularly good. It's like Notrix but, I think, better implemented and more agnostic about what it can connect to.