Using TD2

You can configure the connector to use the TD2 protocol to authenticate the connection. For this authentication mechanism, you must provide your user name and password for accessing your Teradata Database instance.

Before you can save your password or any additional authentication parameters in your DSN, you must first install and configure the Teradata Wallet utility, and then use it to map your password and parameters to reference strings. You would then save those reference strings instead of your password or authentication parameters in your DSN. For more information, see Teradata Wallet.

You can set the connection properties described below in a connection string or in a DSN (in the odbc.ini file). Settings in the connection string take precedence over settings in the DSN. For examples of connection strings, see Using a Connection String.

To configure TD2 authentication:

  1. Set the MechanismName property to TD2.
  2. Set the UID property to your Teradata Database user name.
  3. Set the WalletString property to the Teradata Wallet reference string that is mapped to your Teradata Database password. Use the following format, where [ReferenceString] is your reference string:

    4. WalletString=$tdwallet([ReferenceString])

  4. Optionally, if your database configuration requires you to specify additional parameters for authentication, set the AuthenticationParameter property to the Teradata Wallet reference string that is mapped to your authentication parameters. Use the following format, where [ReferenceString] is your reference string:

    5. AuthenticationParameter=$tdwallet([ReferenceString])

Related topics