For direct connection without preconfigured DSN:

import pyodbc conn = pyodbc.connect('DSN=Teradata_Dev;UID=user;PWD=pass') cursor = conn.cursor() cursor.execute("SELECT COUNT(*) FROM dbc.tables") print(cursor.fetchone())

It enables ODBC-compliant applications (Power BI, Tableau, Excel, Python, R, SSIS, etc.) to connect to a Teradata Vantage database.