should I install odbc driver or that's automatically done by conda install teradata?
jameswang2015 opened this issue · 4 comments
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
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/
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
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");
Do you know if https://pypi.org/project/teradatasql/ is going to be included in github?