Using Teradata Negotiating (TDNEGO)

You can configure the connector to select the authentication mechanism to use through Teradata Negotiating. Depending on the mechanism that the connector selects as a result of the negotiation process, you might need to provide a user name and password.

If you want to save any additional authentication parameters in your DSN, you must first install and configure the Teradata Wallet utility, and then use it to map your parameters to a reference string. You would then save that reference string instead of your 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 TDNEGO authentication:

  1. Set the MechanismName property to TDNEGO.
  2. 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:

    3. AuthenticationParameter=$tdwallet([ReferenceString])

Related topics