Hi
I’m an ex-Notes developer (my company moved me on to other things)who’s been asked to give my opinion on an application design proposal from a consultancy firm. The requirements are for a Notes mail file to be used for feeding a relational (Sybase) database with queries coming in from clients, internal departments etc.
To my mind this sounds like a reasonably simple thing to do, just trigger an agent (before or after new mail or even schedule an agent every few minutes), which passes the required data into a SQL statement which loads into the RDBMS.
My question(s) :
- are there any possible performance issues with mail-triggered agents (if so can you give me details)? The expectation is that the mail file may eventually receive several thousand mails a day
gs simple.
- the consultancy firm have come up with 3 alternative recommendations : using a product called iWay (I have never heard of), using the Java API to read the mails from the application (the front-end is written in Java) using IMAP protocol or using Domingo. Are there any legs in these proposals?
Any thoughts, suggestions much appreciated