Using python 3.7, with sqlalchemy and teradatasqlalchemy installed as well, the following code
does not produce an LDAP encrypted request. The connection is rejected with the following error:
sqlalchemy.exc.DatabaseError: (teradata.api.DatabaseError) (210, '[28000] [Teradata][ODBC Teradata Driver][Teradata Database] (210) The UserId, Password or Account is invalid. FailCode = -8017')
(Background on this error at: http://sqlalche.me/e/4xp6)
From my DB administrator, I know that my connection attempts are registering as authentication=TD2, rather than authentication=LDAP
from sqlalchemy import create_engine
connection_str = 'teradatasql://{username}:{password}@{hostname}/authentication=LDAP'.format(
hostname=hostname,
username=username,
password=password)
td_engine = create_engine(connection_str)
Using python 3.7, with sqlalchemy and teradatasqlalchemy installed as well, the following code
does not produce an LDAP encrypted request. The connection is rejected with the following error:
sqlalchemy.exc.DatabaseError: (teradata.api.DatabaseError) (210, '[28000] [Teradata][ODBC Teradata Driver][Teradata Database] (210) The UserId, Password or Account is invalid. FailCode = -8017')
(Background on this error at: http://sqlalche.me/e/4xp6)
From my DB administrator, I know that my connection attempts are registering as authentication=TD2, rather than authentication=LDAP