We have 3 separate databases - SQL Server 1, SQL Server 2 & Oracle. I need to schedule a job that would retrieve the data from the Oracle & SQL Server 1 databases, massage the data and then insert it into SQL Server 2. This job needs to run at a particular time everyday.
Would the Timer implementation be enough for this functionality?
Do I need to put this job/app in a servlet container or would a standalone java class suffice?