We need to load data from Intersystems Cache system using Teradata TPT. Which ODBC (Data Direct) needs to be used for this source as I can only find drivers for Oracle, SQL Server, DB2 supplied with Teradata TTU (version 15.10). Is there a list provided by either Teradata or Progress on what drivers to be used for a particular source.
No I don't think there's a list. For this data source type I think you'll have to provide the ODBC driver. Note the following from the TPT 16.00 user guide
"The ODBC operator is optimized
and certified to work with Progress DataDirect, Simba and MS SQL Server ODBC drivers.
Attempting to use this operator with any other ODBC driver may have unexpected results and
possible decreased performance."