LDAP (Lightweight Directory Access Protocol) is a directory information service that allows you to centrally store information and share it across an IP network. In an LDAP service, information is stored in objects called entries, which can contain a variety of data—including authentication information. LDAP entries are often used to store authentication information because data storage is centralized, thereby simplifying maintenance when changes occur. The LDAP mechanism is available on all supported client and server platforms, which provide an LDAPv3 compliant library.

To configure the driver to use LDAP 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 ldap.
  • 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 LDAP user ID.
  • Set the Realm (Realm) option to specify the the LDAP domain. (The equivalent connection string attribute is AuthenticationDomain.)
  • Set the TD User Name (TDUserName) option to specify the Teradata user name.
  • Set the Profile (Profile) option to specify the Teradata profile for the LDAP authentication mechanism. (The equivalent connection string attribute is TDProfile.)
  • Set the Default Role (DefaultRole) option to specify the Teradata Role. (The equivalent connection string attribute is TDRole.)

The following examples show the connection information required to establish a session with LDAP authentication.

Connection string

DRIVER=DataDirect 8.0 Teradata;DBCName=myserver;PortNumber=1025;
SecurityMechanism=ldap;DatabaseName=mydb;AuthenticationUserID=userldap;
Realm=sampledomain;TDUserName=teradatauser;Profile=teradataprofile;
DefaultRole=teradatarole;

odbc.ini

[Teradata]
Driver=ODBCHOME/lib/xxtera80.yy
...
DBCName=myserver
...
PortNumber=1025
...
Database=SampleDB
...
SecurityMechanism=ldap
...
AuthenticationUserID=userldap
...
Realm=sampledomain
...
TDUserName=teradatauser
...
Profile=teradataprofile
...
DefaultRole=teradatarole
...