From within Apex, is it possible to connect to another database, on possibly another server and select data from it, updating a 'local' database?
Is it possible to build connection strings etc that can allow you to prompt for a userID/password and then run the SQL?
Both databases are within the same corporate network and are accessible with SQL Developer etc.
This might also help
My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0