MSDN: SQL Server Distributed Queries - OLE DB Provider for ODBC.Select * from TD.NorthwindEF.Customers References: The Teradata Database does not support Catalog leave it blank.The Linked Server Name crated in step 3 above.

Execute a SELECT statement using a 4 part name ( LinkedServerName.

Set the With password field to the Teradata Database Password.

Set the Remote login field to the Teradata Database User Id.

Select Be made using this security context.

Set the Data Source to the ODBC DSN Name created in section 2 above.

Set the Product Name to Teradata Database.

Select Microsoft OLE DB Provider for ODBC Drivers.

Assign a name to the Linked Server I suggest a single word name like TD.

Make Sure MSDASQL (Microsoft OLE DB Provider for ODBC Drivers) is installed on the server.

Select the Data Source created in the previous sectionĤ.

Select Use data source name radio button.

Select the Microsoft OLE DB Provider for ODBC Drivers.

Double-Click the file to display the Data Link Properties dialog box.

Change the file extension to UDL (for example Foo.UDL).

Right-Click and select ' New' - > ' Text Document'.

Fill in the required fields in the ODBC Driver Setup for Teradata Database dialog box.

User DSN will not work because SQL Server service will not have access to the User DSNs. Start the ODBC Data Source Administrator.You can use the steps in the 'Test the ODBC Data Source' section to see a list of OLE DB Providers currently installed on your server. The OLE DB Provider for ODBC 64-bit if it is not included in your OS.

This blog outlines the steps to create a SQL Server 2008 (64-bit) R2 Linked Server to the Teradata Database.

Download sql server 2008 r2 64 bit