Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    93

    Unanswered: Oracle to DB2 Connectivity

    We have a application running on UDB 7.2 Fixpack 10 on AIX 4.33.

    The other application runs on Oracle 817 on Windows.

    I am new to this connectivity thing so asking this question..

    How can the Oracle Application trnasfer data back and forth to the Db2 database. I know Oracle's OTG is one solution.

    a) Can Db2 connect be used for this ??

    b) Or is there a UDB ODBC Driver for this ??

    thanks a ton...

  2. #2
    Join Date
    Jan 2002
    Location
    USA
    Posts
    53
    I think there is a product something like DB2 relational connect can do it.
    http://www.ibm.com/br/products/softw...lconnect.phtml


    WTH

    ljrong

  3. #3
    Join Date
    Oct 2003
    Posts
    93
    any other solution ?
    DB2 connect is for OS/390 or As/400 only..

  4. #4
    Join Date
    Sep 2003
    Posts
    84

    Re: Oracle to DB2 Connectivity

    think DB2 federated server is the solution. Take a look at the federated server manual available in IBM site

  5. #5
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Relational Connect

    HI,

    There is a concept of a relational connect that allows you to interchange data between Oracle and DB2.

    Please do check on the details on the IBM Suite of products.

    That would really help.

    Nitin.

  6. #6
    Join Date
    Sep 2003
    Posts
    218
    I think Dipanjan is spot-on. Federated access is the solution. There is a whole bunch of good documents on IBM site. Federated Systems Guide might suit you well.

    Besides, you can also check out the following link as well. This will outline how federation engine work.

    http://www-106.ibm.com/developerwork...0304lurie.html

    There is a utility called "Information Integrator" from IBM. Please check the IBM site for more information.

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •