I have a project where I am reading data from a Notes View and writing to an Oracle table on a schedule using an agent. The Domino server is 6.5.1 moving to (7.0.2) running on Solaris. I have never worked with DECS or LEI and running through the HELP and manuals of both.
Does anyone have any suggestions or recommendations? I do not want to go to far down a path that will not work.
Thank in advance for your assistance.
Subject: Writing Data from Domino to Oracle
I suggest using a Scheduled Java Agent using the Oracle JDBC driver.
Subject: Writing Data from Domino to Oracle
If you have LEI this is pretty straightforward to do. You can do this with a forms based approach aka no programming if data is normalized enough.
Otherwise look at LC LSX coding to push the data from Notes>RDBMS.
A great resource for LC LSX coding and LEI of course is LEI 6 Redbook
Also another great place for question is the Lotus Enterprise Integration Forum.