search

Teradata / PyTd

A Python Module to make it easy to script powerful interactions with Teradata Database in a DevOps friendly way.
MIT License
108 stars 43 forks source link

should I install odbc driver or that's automatically done by conda install teradata? #114

Open jameswang2015 opened 5 years ago

jameswang2015 commented 5 years ago

I did conda install teradata (successfully) but when I run the connection I get "Driver Not Found" error ( I have put details here https://github.com/Teradata/PyTd/issues/92. so my question is: is this because I didn't install odbc driver? I thought it should be taken care by conda install teradata already. Please help and let me know how should I install the odbc driver if that's the case. Thanks

escheie commented 5 years ago

You need to install the Teradata ODBC driver. There is a new Teradata SQL Driver for Python that does not require Teradata ODBC to be installed. Here is the link if interested: https://pypi.org/project/teradatasql/

jameswang2015 commented 5 years ago

Thanks @escheie. Any guideline to install Teradata ODBC driver? I can google it but if you have something concrete I can just simply follow and make it work. Thanks

jameswang2015 commented 5 years ago

Ok, I downloaded and installed ODBC driver and it works now! Now my question or concern is more security issue: Is that safe to put user name and password in the connection as below? I think the module already encrypted them but just want to double check and make sure it. Thanks

session = udaExec.connect(method="odbc", system="xxxxxxx", username="xxxx", password="xxxxxx");

Proteusiq commented 5 years ago

Do you know if https://pypi.org/project/teradatasql/ is going to be included in github?