9i to UDB using Generic Conectivity

From: sundeep maini <sundeep_maini_at_yahoo.com>
Date: Fri, 27 Aug 2004 07:41:25 -0700 (PDT)
Message-ID: <20040827144125.11977.qmail@web50905.mail.yahoo.com>

We are looking to pull some data (batch jobs no distributed OLTP) from a SAP/UDB on AIX into our 9i DB on AIX. We do have a gateway to mainframe DB2 but not to the UDB on AIX. The Hetrogeneous Services Admin guide seems to explain how to get the Generic connectivity set up.

Is anyone on the list using this kind of connectivity? Can you please share you experience with performance and set up bottlenecks? Also, which vendor's ODBC drivers are you using? I would greatly appreciate if you can list the s/w components involved in the end to end connectivity and what features you had difficulty using or any SQL caveats you learnt by using this architecture.

This is to avoid using FTP and synchronized push and pull at the two ends. However any suggestions are welcom.....

TIA
Sundeep

---

Sundeep Maini
Consultant
Currently on Assignement at Caterpillar Peoria sundeep_maini_k_at_cat.com                 

---

Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Aug 27 2004 - 10:44:48 CDT