DataConnect offers the Full Experience with Teradata. This allows you to create queries using a tile-based drag and drop query builder. The tile-based editor functions with Teradata Provider for .NET 4.0, OLEDB and ODBC.
However, automatic joins are currently only supported on Teradata Provider for .NET 4.0 based connections.
We recommend using the Teradata Provider for .NET 4.0 where available.
Create a New Connection
To create a new connection to a Teradata server, make sure you are on the Connections tab. Then press the (+) icon at the very left hand side of the window.
Give your Connection a Name
You then need to give your connection a name, and optionally a description.
You then have a choice of connection technologies. We recommend using the Teradata Provider for .NET 4.0 where possible.