sqlalchemy-teradata
sqlalchemy-teradata copied to clipboard
LDAP not working on Mac OSX
trafficstars
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)