Introducing Teradata Wallet

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Enthusiast

Re: Introducing Teradata Wallet

When calling tdwallet from a Teradata Python module it fails if the user name is stored in tdwallet. If only the password (string "database_pw") is retrieved from the tdwallet the login completes fine. What is the correct way of using tdwallet here or is it a bug?

 

here are the relevant strings from the python script

import teradata
session = udaExec.connect(method="odbc", system="my.td.url.com"
, username="$$tdwallet(user)", password="$$tdwallet(database_pw)")

Error message

python3.5/site-packages/teradata/tdodbc.py", line 209, in checkStatus
raise DatabaseError(i[2], u"[{}] {}".format(i[0], msg), i[0])
teradata.api.DatabaseError: (8017, '[28000] [Teradata][ODBC Teradata Driver][Teradata Database] The UserId, Password or Account is invalid. , [Teradata][ODBC Teradata Driver] Not enough information to log on')

 

Here is the content of the tdwallet.log

CALL wallet constructor() (tid=0x00C7928EC87F0000)
wallet constructor RETURNS (wallet=0x28E9020,tid=0x00C7928EC87F0000)
CALL getStringValue(stringName="user") (wallet=0x28E9020,tid=0x00C7928EC87F0000)
getStringValue RETURNS <hiddenvalue> (wallet=0x28E9020,tid=0x00C7928EC87F0000)
CALL wallet destructor() (wallet=0x28E9020,tid=0x00C7928EC87F0000)
wallet destructor RETURNS (tid=0x00C7928EC87F0000)
CALL wallet constructor() (tid=0x00C7928EC87F0000)
wallet constructor RETURNS (wallet=0x28F17A0,tid=0x00C7928EC87F0000)
CALL getStringValue(stringName="database_pw") (wallet=0x28F17A0,tid=0x00C7928EC87F0000)
getStringValue RETURNS <hiddenvalue> (wallet=0x28F17A0,tid=0x00C7928EC87F0000)
CALL wallet destructor() (wallet=0x28F17A0,tid=0x00C7928EC87F0000)
wallet destructor RETURNS (tid=0x00C7928EC87F0000)
Enthusiast

Re: Introducing Teradata Wallet

Enthusiast

When calling tdwallet from a Teradata Python module it fails if the user name is stored in tdwallet.

The documentation on this is wrong in the original post .

 

Teradata wallet does not work for username with ODBC Driver.

 

So the problem is within the ODBC Driver, not the Teradata Python Module.

 

ODBC engineering said, at this point we have no plans to retrieve the User-Id from TdWallet.
We (ODBC) do not consider TdWallet a general-purpose repository for configuration information. 

Highlighted
Teradata Employee

Re: Introducing Teradata Wallet

Teradata JDBC Driver Stored Password Protection is now available, beginning with Teradata JDBC Driver version 16.00.00.24.

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#SPPSECTI...

 

Please note that Teradata JDBC Driver Stored Password Protection is separate from Teradata Wallet. At the present time, there is no interoperability between the two features, but that may be added in the future.

Enthusiast

Re: Introducing Teradata Wallet

Hi Shawn,

 

I have installed the TD wallet in my windows DEV server. I have got a windows user id (LAN ID) and teradata functional login id (Batch User) which are different ones.

 

Will I be able to configure the wallet for the TD functional id?  Appreciate if you could help me on this.

 

Thanks,

Enthusiast

Re: Introducing Teradata Wallet

Hi Shawn,

 

I just wanted to know as how we configure the wallet in the windows server

 

I have a Qlikview dev server which is windows based. I have a service account which is LAN login and there is a functional Teradata login.

 

I have installed the Teradata utilities in the dev server. Can I configure the password string in the wallet for my functional user (Teradata Login) or will the wallet only store the password for the windows server?

 

Thanks,

 

Tags (1)