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.

Re: Introducing Teradata Wallet

Is tdwallet supposed to work with Sql Assistant and Teradata.Net? It works fine with SQLA and ODBC. We are using SQLA 14.01.00.01, tdwallet 14.00.00.05 and Teradata.Net 14.00.00.01
Teradata Employee

Re: Introducing Teradata Wallet

Hi Shawn,

How many character could we use as item name and item value.

Thanks
-jeffry

Re: Introducing Teradata Wallet

response to an incident: Teradata Wallet presently is not supported by the .NET Data Provider
Teradata Employee

Re: Introducing Teradata Wallet

Jeffry,

You asked:

How many character could we use as item name and item value.

Execute:

tdwallet help limits

to see the implementation limits for Teradata Wallet.

Thanks!

-shawn   :-)

Teradata Employee

Re: Introducing Teradata Wallet

Hi Jeffry,

You asked:

The process of iterative substitution, it would be a infinite loop or not?

I have add item like this:

./tdwallet add abcd -> $tdwallet(efgh)

./tdwallet add efgh -> $tdwallet(abcd)

What is the real password when i running -w $tdwallet(abcd).

It appears that you added a circular reference to your wallet; I suggest avoiding this.   :-)

At present this could result in Teradata CLIv2 hanging in an infinite loop.  There is an open issue to detect this scenario (CLAC-28850).

Thanks!

-shawn   :-)

Teradata Employee

Re: Introducing Teradata Wallet

Hi JerryZott,

You asked:

Is there a way to pass the "password" or other encrypted text to the 'add' or 'addsk' command?





On Unix systems, the tdwallet tool reads security sensitive information from the terminal device.  It is possible to use the expect tool (see http://en.wikipedia.org/wiki/Expect) to pass this information to the tdwallet tool.

Thanks!

-shawn   :-)

Teradata Employee

Re: Introducing Teradata Wallet

Hi Scaster,

You wrote:

does anyone have instructions for how to reference a wallet string from within a TPT script? I have tried several variations on the syntax used for bteq without success.

Specifically, the TPT script in the DDL operator, for example, requires a value for UserPassword:

DEFINE OPERATOR DDL_OPERATOR

TYPE DDL

ATTRIBUTES

(

VARCHAR PrivateLogName = 'ddl_log',

VARCHAR TdpId = @jobvar_tdpid,

VARCHAR UserName = @jobvar_username,

VARCHAR UserPassword = @jobvar_password,

VARCHAR WorkingDatabase = @jobvar_working_database,

VARCHAR ARRAY ErrorList = ['3807','3803','5980']

);

How can I replace that file or command-line provided @jobvar_password with a tdwallet reference?





In your operator definition, you could replace:

VARCHAR UserPassword = @jobvar_password,

with:

 VARCHAR UserPassword = '$tdwallet(password_proddev)',

Alternatively, you could change your job variables file from having something like:

jobvar_password        =  'UR1geek2B'

to instead contain:

jobvar_password        =  '$tdwallet(password_proddev)'

Or, if you are used to specifying this on the command line like:

tbuild -f weekly_update.tbr -u "jobvar_password = 'UR1geek2B'"

you could instead use:

tbuild -f weekly_update.tbr -u "jobvar_password = '\$tdwallet(password_proddev)'"

Hope it helps!

-shawn   :-)

Enthusiast

Re: Introducing Teradata Wallet

Hi Shawn,

Can the TDWallet be used from within a .bat ?

I need to invoke Selector.exe (for use in TVA).

By Example:

PROMPT $T$G

@ECHO **********************************************

SET PATH_TVA=C:"\Program Files\NCR\Teradata Value Analyzer 3.0"

SET JOB=RNCP

@ECHO **********************************************

@ECHO *                       MODULO SELECTOR                                  *

@ECHO **********************************************

C:

CD %PATH_TVA%

Selector.exe UserID=tva_usr Password=tva_psw RunGroupId=14 Resume=NO

Regards.

Teradata Employee

Re: Introducing Teradata Wallet

Dixxie wrote:

Can the TDWallet be used from within a .bat ?

As mentioned in the Notes above, any application that initiates logon processing using Teradata CLIv2 for Network-Attached Systems (14.0 or later) can utilize Teradata Wallet. Whether this application is executed directly or from a script is irrelevant.

I do not know which interface is used by Selector.exe for logon processing.

Enthusiast

Re: Introducing Teradata Wallet

Does Teradata wallet works on JDBC Connection?