1. Download and install

  1. TheODBC Driver for Teradata64-bit
  2. TheOLE DB Provider for ODBC64-bit if it is not included inyour OS. 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.

2. Create an ODBC Data Source

  1. Start theODBC Data Source Administrator
  2. SelectSystem DSN. User DSN will not work because SQL Server service will not have access to the User DSNs.
  3. ClickAdd ...button
  4. SelectTeradataODBC driver
  5. Fill in the required fields in theODBC Driver Setup for Teradata Databasedialog box

3. Test the ODBC Data Source

  1. StartWindows Explorer
  2. Navigate to a temporary directory
  3. Right-Click and select "New" - > "Text Document"
  4. Change the file extension toUDL(for example Foo.UDL)
  5. Double-Click the file to display theData Link Propertiesdialog box
  6. Select theProvidertab
  7. Select theMicrosoft OLE DB Provider for ODBC Drivers
  8. Select the Connection tab
  9. SelectUse data source nameradio button
  10. Select the Data Source created in the previous section
  11. Specify a Teradata User ID
  12. Specify a Password
  13. Click theTest Connectionbutton

4. Create a SQL Server Linked Server Object

  1. StartSQL Server Management Studio
  2. Expand Server Objects
  3. Expand Linked Servers
  4. Expand Providers

  1. Make Sure MSDASQL (Microsoft OLE DB Provider for ODBC Drivers)is installed on the server
  2. Right Click on Linked Servers
  3. Select New Linked Server...
  4. Assign a name to the Linked Server; I suggest asingle word name likeTD.
  5. SelectMicrosoft OLE DB Provider for ODBC Drivers
  6. Set the Product Name to Teradata Database.
  7. Set the Data Source to the ODBC DSN Name created in section 2 above.

  1. SelectSecurity page
  2. SelectBe made using this security context
  3. Set the Remote login field to the Teradata Database User Id
  4. Set the With password field to the Teradata Database Password

  1. Click OK button

5. Test the new Linked Server

  1. Open a New Query
  2. Execute a SELECT statement using a 4 part name (LinkedServerName..DatabaseName.TableName).
  3. The Linked Server Name crated in step 3 above.
  4. The Teradata Database does not support Catalog; leave it blank.
  5. TheDatabase Name
  6. The Table Name

1 / Select* fromTD..NorthwindEF.Customers