Return
-
Title
Trouble using cross platform or heterogeneous query on Oracle and Teradata ODBC -
Description
I'm having some trouble using the cross platform or heterogeneous query when running SQL between an Oracle connection and an ODBC connection for Teradata.
-
Resolution
Ensure you have the Teradata .NET Data Provider (13.10 or later) to use a Teradata native connection in Toad.
To use a Teradata connection in a cross-connection query, you must also install a Teradata (13.10 or later) ODBC driver.
In the Base edition of Toad Data Point, to use a Teradata connection in a cross-connection query, you must use a Teradata ODBC connection instead of a native connection.