1

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");
Maria Nazari
  • 660
  • 1
  • 9
  • 27

1 Answers1

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.

topchef
  • 19,091
  • 9
  • 63
  • 102
  • Thank you, I tried your recommendation but it didn't work. Maybe I'll try connecting using R instead. – Maria Nazari Nov 20 '18 at 23:12
  • 1
    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: http://rpubs.com/grigory/introtoaster – topchef Nov 21 '18 at 18:54
  • 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. – Maria Nazari Nov 27 '18 at 23:05
  • @MariaNazari how did you end up connecting to python ? – toceto Jan 17 '19 at 14:49
  • 1
    @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) – Maria Nazari Jan 17 '19 at 17:28