I am trying to retrieve data from a Lotus Notes database within which I already have a view. I manage to create an ODBC connection and use this with MS Access or Excel but I'd like to create a scheduled job on a java application to inject the data in a MS SQL Server database.
I got a bit lost in all the documentation on Internet; Do you guys have a sample of a Java code which would allow me to1. Connect to the database2. "Query" the view ("SELECT * FROM..."?)3. Get a resultset which I can iterate throughI've read that I can avoid using the Lotus SQL driver by importing the notes.jar in my project...
Thank you for your help