Teradata 1 and Teradata 2 authentication

The driver supports Teradata 1 and Teradata 2 authentication (TD1 and TD2). It authenticates the user to the database using a valid user name and password. Teradata 2 encryption key offers a higher degree of security when compared to Teradata 1. When the Teradata 2 (TD2) mechanism is selected, both logon string and data are encrypted.

To configure the driver to use TD1/TD2 authentication:

• Set the DBC Name or Alias (DBCName) option to specify the IP address or the DBC name of the Teradata server to which you want to connect.
• Set the Port Number (PortNumber) option to specify the port number of the server listener. The default is 1025.
• Set the Security Mechanism (SecurityMechanism) to TD1 or TD2.
• Set the Default Database (Database) option to specify the name of the database to which you want to connect.
• Set the Authentication User ID (AuthenticationUserID) option to specify your user name.
• Set the Authentication Password (AuthenticationPassword) option to specify your password.

The following examples show the connection information required to establish a session using TD1/TD2 authentication.

Connection string

DRIVER=DataDirect 8.0 Teradata;DBCName=MyServer;PortNumber=1025;
SecurityMechanism=TD2;Database=SAMPLEDB;AuthenticationUserID=jsmith;
AuthenticationPassword=secret;

odbc.ini

[Teradata]
Driver=ODBCHOME/lib/xxtera28.yy
...
DBCName=myserver
...
PortNumber=1025
...
SecurityMechanism=TD2
...
Database=SampleDB
...
AuthenticationUserID=jsmith
...
AuthenticationPassword=secret
...