DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle 9i/sybase to 9i interface

  1. #1
    Join Date
    Jul 2003
    Location
    Orange County, CA
    Posts
    1

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

  2. #2
    Join Date
    Jul 2003
    Posts
    59
    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
  •  


Click Here to Expand Forum to Full Width