![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 07 Jun 2011 @ 15:27:08 GMT
Subj: | | Re: Loading Data from Oracle to Teradata through TPT |
|
From: | | John_Wight |
Yong Boon wrote:
| Is DataDirect ODBC driver a MUST for TPT ODBC operator to interface with Oracle, could we use the native driver provided by Oracle? | |
I'm not an ODBC 'expert' , but I would have thought any 'ODBC compliant' driver for Oracle would work. We use Microsoft ODBC driver for Oracle
and it works a charm for our new TPT environment. We actually use it to do a single data extract and dual load that data into two different tables
on two different systems at the same time with TPT and it works great. We do use the UPDATE operator instead of the LOAD but don't think that
makes a difference.
Hope this helps.
JK
| |