 |
 |
Archives of the TeradataForum
Message Posted: Wed, 08 Jun 2011 @ 14:49:02 GMT
| Subj: | | Re: Loading Data from Oracle to Teradata through TPT |
| |
| From: | | John_Wight |
Yong Boon wrote:
| | Thanks for your feedback. By any change you've tested on Unix environment? The reason l'm asking DataDirect ODBC component is because it is
mentioned in the TPT References document, in TTU12/13 "Note: Use of the ODBC operator requires that a copy of the DataDirect ODBC driver, version
5.2, be installed on the system from which the Teradata PT job script is run." | |
Unfortunately no, we are a Windows shop (excpet for our AS 400 and TD (Linux). I Believe DataDirect is a vendor that TD uses to source their
ODBC driver these days. I don't see why only a DataDirect driver on Unix for Oracle would work. As indicated, any ODBC 'compliant' version (to the
ODBC level certified by that TPT release) should work, but you'd have to test.
These other DBMS drivers are not provided by Teradata but used in connectivity to source data through their TPT enviornment with TD using ODBC
as there connector 'standard' interface.
Again, hope this helps.
JK Wight
EDW - Integration/DBA
'Terafied' Professional
Swift Transportation Corp.
'Have trucks - will transport'
| |
