Connecting to Aster Teradata Python

Question

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");

topchef · Accepted Answer · 2018-11-20 15:19:04Z

2

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.

answered Nov 20, 2018 at 15:19

topchef

19.9k9 gold badges69 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Maria Nazari Over a year ago

Thank you, I tried your recommendation but it didn't work. Maybe I'll try connecting using R instead.

topchef Over a year ago

I used R RODBC package and had no problems on Windows, but never tried that on Mac. Eventually, it'll be all about ODBC support on a client side. You can related example here: rpubs.com/grigory/introtoaster

Maria Nazari Over a year ago

Update: thank you again for all your help, because of your advice I was finally able to connect to Python as well. I first connected to R and it took me a few more days to figure out why Aster can connect to R but not Python.

toceto Over a year ago

@MariaNazari how did you end up connecting to python ?

Maria Nazari Over a year ago

@toceto download pyodbc and the aster driver like topchef mentioned and use the following syntax to connect: conn = pyodbc.connect( 'DRIVER={Aster ODBC Driver};SERVER=xxx.xxx.xx.xx; PORT=xxx;DATABASE=xx;UID=xxxxx;PWD=xxxxx)

Collectives™ on Stack Overflow

Connecting to Aster Teradata Python

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related