ODBC Driver for Teradata

Build 20.0.7654

Windows DSN Configuration

Using the Microsoft ODBC Data Source Administrator

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.

Complete the following steps to edit the DSN configuration:

  1. Select Start > Search, and enter ODBC Data Sources in the Search box.
  2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
  3. Click the System DSN tab.
  4. Select the system data source and click Configure.
  5. Edit the information on the Connection tab and click OK.

Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2017 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

The driver wraps the official Teradata Database driver; you can connect to the CData ODBC Driver for Teradata using the same connection properties and access the same functionality as the underlying Teradata driver. You also need to install the official driver alongside the CData ODBC Driver for Teradata.

Deploying the Provider

To connect using the CData ODBC Driver for Teradata, you also need to install the Teradata .NET Data Provider into the GAC.

Connecting to Teradata

Required Properties

To connect to Teradata, provide the following authentication information and specify the database server name.

  • User; Set this to the user name of a Teradata user.
  • Password: Set this to the password of the Teradata user.
  • DataSource: Specify the Teradata server name, DBC Name, or TDPID.
  • Port: Specify the port the server is running on.
  • Database: Specify the database name. If not specified, the driver connects to the default database.
Refer to the Teradata .NET Data Provider documentation for more information on the available properties.

TLS/SSL Configuration

Enable DataEncryption to encrypt connections with TLS/SSL.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654