Search code examples
pythondatabase-connectionteradatateradata-asteraster

Connecting to Aster Teradata Python

I want to connect to Teradata Aster, I have been searched through multiple sites and read documentation but with not luck. I am able to connect to Teradata just fine, but not to Aster Teradata.

code for teradata that works, but I don't know how to tweak this to work for aster: 

import teradata
udaExec = teradata.UdaExec(appName="", version="1.0", logConsole=False)
session = udaExec.connect(method="odbc", system="TDD...", username="...", password="...", authentication="LDAP");
Solution

  • To connect to Aster use native Teradata Aster ODBC driver. Follow this link and choose "Aster Client Tools" for your platform to find and download the driver.

    Then use a Python package for ODBC database connectivity such as pyodbc. I used similar method in R but never with Python, one example I found for Python and Teradata is here.