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.....