-
oracle 9i/sybase to 9i interface
I'm looking for suggestions on which tools/utilities could be used to design/program 2 separate interfaces. The first interface would be from a Internal 9i DB (A) to a External 9i DB (B). The 2nd interface would be from a Sybase DB to the same 9i DB (B). I'm aware that SQL Loader could be used for a static transfer of tables/tablespaces, but I've been tasked to design a dynamic/online interface to transfer the data as it's committed at approximately 5 minute intervals. The difference in the interfaces (9i to 9i versus Sybase to 9i)is that the Sybase DB to 9i DB interface will include an XML data with no/minimal constraints on the data.
Thanks much.....
-
Check out "Heterogeneous Connectivity". It allows Oracle to sort of seamlessly connect to other DBMSs.
Oracle Hetero doc
Tom Best
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|