Best Practice to fetch SQL Server data and Insert into Oracle Tables

Hello,

I want to read sqlserver data everry half an hour and write into oracle tables ( in two different databases). What is the best practice for doing this?

We do not have any database dblinks from oracle to sqlserver and vice versa.

Any help is highly appreciable?

Thanks

[306 byte] By [ponica] at [2007-11-27 5:39:36]