TD Wallet and TPT

Tools & Utilities

TD Wallet and TPT

It's easy enough to get tdwallet working with bteq, but 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?

Thanks.

Tags (1)
1 REPLY
Enthusiast

Re: TD Wallet and TPT

 

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)'"


 

Reference: http://developer.teradata.com/tools/articles/introducing-teradata-wallet (Read the comments)