Teradata Wallet

Tools
Enthusiast

Teradata Wallet

Can someone direct me to documentation on how to use Teradata Wallet? Specifically, is it just for v14 (or can it be used in v13)  and an example of how to incorporate it into a BTEQ script.

R

Tags (1)
8 REPLIES
Teradata Employee

Re: Teradata Wallet

Hi Rluebke,

Teradata Wallet is supported with Teradata Database versions 13.10, 13.0, 12.0, and V2R6.2.

To use an item from your wallet when connecting to a Teradata Database, you can supply $tdwallet(put_item_name_here) in place of your database password.

For example, if you add an item to your wallet as follows:

  $ tdwallet add password_proddev

  Enter desired value for the string named "password_proddev":

  <here_you_type_your_Teradata_Database_password>

  String named "password_proddev" added.

  $

You could then use a BTEQ script like:

$ cat deptquery.txt

  .logon proddev/joem,$tdwallet(password_proddev)

  .SET SEPARATOR ' | '

  SELECT * FROM department;

  .logoff

  .exit

  $ bteq < deptquery.txt

  BTEQ 14.00.00.00 Mon Oct 12 15:55:38 2011

  +---------+---------+---------+---------+---------+---------+---------+----

  .LOGON slugger/joe,

  *** Logon successfully completed.

  ...

This technique works with software that uses Teradata CLIv2 to connect to the Teradata Database such as:

    - Basic Teradata Query Utility (BTEQ)

    - Teradata FastLoad

    - Teradata MultiLoad

    - Teradata Parallel Data Pump (TPump)

    - Teradata FastExport

    - Teradata ARC

    - Teradata Preprocessor2 (PP2)

    - Teradata Parallel Transporter (TPT)

You must be using a TTU 14.0 version of Teradata CLIv2 (preferably the 14.00.00.02 version of Teradata CLIv2, or later) for this to work.

Hope it helps!

-shawn   :-)

Teradata Employee

Re: Teradata Wallet

A clarification: Teradata Wallet is included only in the 14.0 version of the Teradata Tools and Utilities (TTU).

Thanks!

-shawn   :-)

Enthusiast

Re: Teradata Wallet

Cool feature :-) Is there one for Mainframe TTU 14.0 ?

Re: Teradata Wallet

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 wallet reference?

Thanks.

Teradata Employee

Re: Teradata Wallet

Have you tried putting the text "$tdwallet(put_item_name_here)" as the value of the UserPassword attribute (or on the command line with the -u option, or in the job variable file)?

-- SteveF

Re: Teradata Wallet

Hi

I tried using TDWallet with two different utilities .BTEQ (T14.0.0.4) and ARCMAIN (T14.0.0.3). It seemed to have worked fine with BTEQ but gave an error in ARCMAIN.Im using CLIV2 T14.0.0.4.


BTEQ script

.logon myprod/nuser1,$tdwallet(prod1)

.logoff


BTEQ 14.00.00.04 

+---------+---------+---------+---------+---------+---------+---------+----

.logon myprod/nparcuser1,

 *** Logon successfully completed.

ARCMAIN

-------------

10/03/2012 03:03:47     ***   ****    ****

10/03/2012 03:03:47    *   *  *   *  *        PROGRAM: ARCMAIN

10/03/2012 03:03:47    *****  ****   *        RELEASE: 14.00.00.03


logon myprod/nuser1,$tdwallet(prod1);

10/03/2012 03:04:11  LOGON MYPROD/nuser1,;

10/03/2012 03:04:11  *** Failure 8017:The UserId, Password or Account is invalid.

KJH
Teradata Employee

Re: Teradata Wallet

Since TD Wallet usernames and passwords contain special characters, you must use double quotation marks to log on, such as:

logon myprod/nuser1,"$tdwallet(prod1)";

Re: Teradata Wallet

how do we specify the LDAP in Teradata wallet