Pedro,
This is a very useful tip.
As an alternative to linked servers and for option 1 I also have an example (Platform 9 only).
This sample allows you to understand
"How to connect programmatically to a Lotus Note DB file with the Outsystems Platform".
Instructions:
- Install Lotus Notes Client (ex: NOTES_9.0.1_WIN_EN_EVALUATION) on OutSystems Platform Server and test it by opening a NSF file (installation folder ....\IBM\Notes\Data includes several NSF files you can use).
- Publish the application (LotusNotesInteropSample) attached into the OutSystems Platform (V9) server
- Go to MS IIS OutSystems Platform Server and create a 32 bit Application pool and move the LotusNotesInteropSample application to this application pool. When you create the 32 bit application pool you must set its pipeline mode to "Classic".
- Test the application by inserting the input parameters (NSF file path - make sure access permissions are ok, View name and View Columns to read). You can test it using DB file names.nsf (it comes with lotus client), using View My Contacts (insert some contacts first using Lotus Client) and columns like FullName, Address, PhoneNumber...
I hope this code attached is also a good help for you.
Cheers,
FM