- 1 year ago
Teradata connection string using Windows Authentication
To establish a Teradata connection using Windows Authentication, you can use the following connection string format in your code:
pythonimport pyodbc
connection_string = "DRIVER={Teradata};DBCNAME=your_databasename;Authentication=LDAP;TDWalletIntegration=No;DATABASE=your_database;LOGMECH=LDAP;UID=your_username;PWD=your_password;"
conn = pyodbc.connect(connection_string)
Replace the placeholders your_databasename
, your_database
, your_username
, and your_password
with the appropriate values for your Teradata environment.
Make sure you have the pyodbc
package installed in your Python environment to use the pyodbc.connect()
method.
This connection string assumes that you have the Teradata ODBC driver installed on your system. Adjust the DRIVER
value if you are using a different Teradata driver.
Note that Windows Authentication relies on your Windows credentials to authenticate with the Teradata server, so you don't need to provide a username and password explicitly in the connection string.
Remember to handle any potential exceptions or errors that may occur during the connection process.