I would like to ask for recommendations to move large quantities of file attachments - mostly PDFs and Tiff files out of the NSF store to some other storage system (DB2/SQL?) so that from a web app the attachments can be read or written to.
Important requirements are:
Maintain PDF byteserving capability over the web
Maintain reader security - if the user can’t access a notes document, they should not be able to access the associated file attachment(s) either.
For attachments with indexable text, FTSearch should be possible
Subject: RE: Recommendation to move large set of fileattachments out of NSF for web access
You’re asking rather a lot of your relational database server that it should duplicate Notes security features – not to mention contributing to the full-text index. You’re going to duplicate all the Notes userids into – let’s say – DB2 userids, and all the Notes groups into DB2 groups, so that each user’s access can be determined?
Look into Domino.Doc. It does what you’re asking for.
Otherwise, the easist way to make Domino file attachments available to browser users, is to turn on the HTTP capability of the Domino server and just read them directly from the Notes database on request. The full-text index will index them, and Notes access controls are automatically applied since they are still a part of the document.