I'm working on a python script that connects to Teradata using teradatasql module, runs a very simple query and returns an output. Here's how I'm currently connecting in DEV. And it's working:
with my.connect(None, host='whomooz', user='guest', password='password', tmode='TERA', logmech='LDAP') as con:
My question is, if I want to use TDWallet for this connect (we use tdwallet at our org for scripts connecting to TD) how can I achieve this?
I think teradatasql python's module relies on JDBC which (unfortunately) doesn't support TDWallet. But teradatasqlalchemy module relies on ODBC which supports TDWallet.
Edit : ok this is false information, please read corrections in the following posts by Fred & Tomnolan.
The teradatasql module is native Python, but is similar to JDBC in that the available Stored Password Protection support relies on the TJEncryptPassword mechanism instead of TDWallet.
@Fred is correct on all points:
Documentation for the teradatasql Python module's Stored Password Protection feature is located here:
@WaldarThe teradatasqlalchemy Python module does not use ODBC.
The teradatasqlalchemy Python module uses the teradatasql Python module, and therefore teradatasqlalchemy uses the Stored Password Protection offered by teradatasql.