Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Jun 2011 @ 15:27:08 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023