Scheduled imports from a Notes database

Hi, I was hoping for some ideas...I need to run some scheduled mirroring from a table in a Notes database into Oracle, and I'm not sure of the easiest way to do this. My environment is:

• Notes/Domino 4.5 database running on a remote server
• Oracle 8 running on an NT 4.0 server

Basically, once a week, I need to update an Oracle table to mirror one of the Notes tables...currently, it's being done semi-manually. I also need to be able to schedule this to run independently. I know I can probably write some VB or Access scripting to connect to both databases via ODBC (there is an ODBC driver for the Notes database), and update the table that way, but there has to be a more graceful solution.

Is there a way via a stored procedure to connect to an ODBC database and run an insert query into a local Oracle table? Or maybe some batch/command-line way of accessing an ODBC data source?

I know there are probably 3rd party tools that will handle this integration, but there must be a semi-manual way to implement it...I don't mind putting the extra time into it, as long as I know where to start.

Thanks in advance for any help/guidance,

Cheers, Colin Mackenzie Received on Tue May 26 1998 - 00:00:00 CDT