NTLM authentication can be used to authenticate with Teradata. The driver supports both NTLM and NTLMC implementations. The driver uses NTLM on Windows clients working with Windows servers if the server is V2R6.0. If the server is pre-V2R6.0, the driver uses NTLM Compatibility on Windows clients working with Windows servers. NTLM is enabled through the Teradata client.

To configure the driver to use NTLM:

  • 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 NTLM or NTLMC.
  • Set the Default Database (Database) option to specify the name of the database to which you want to connect.
  • Set the Authentication UserID (AuthenticationUserID) option to specify the NTLM user ID connecting to the service.
  • Set the Realm (Realm) option to specify the NTLM domain. (The equivalent connection string attribute is AuthenticationDomain.)

The following examples show the connection information required to establish a session using NTLM.

Connection string

DRIVER=DataDirect 8.0 Teradata;DBCName=myserver;PortNumber=1025;
SecurityMechanism=NTLM;DatabaseName=mydb;AuthenticationUserID=jsmith;
Realm=sampledomain;

odbc.ini

[Teradata]
Driver=ODBCHOME/lib/xxtera28.yy
...
DBCName=myserver
...
PortNumber=1025
...
SecurityMechanism=NTLM
...
DatabaseName=mydb
...
AuthenticationUserID=jsmith
...
Realm=sampledomain
...