Excel to Teradata Session logins

Third Party Software
Fan

Excel to Teradata Session logins

Hi all,

Situation

I have a spreadsheet that pulls back multiple tables from Teradata using the Data connection tool within Excel 2010.

Issue

My issue is Excel is requesting me to type my Teradata password in for every table/query bought back/that runs (username is saved).

Question

Is there a way that means I only have to type in my Teradata password once. Then run multiple queries pulling tables back into multiple sheets.

Not used connections much before and cannot find much about them. Preferably don't really want to get into VBA for this.

I know you can have your password saved in automatically but this is not ideal as the report will be distributed.

If anyone can point me to some resources or respond I would appreciate it very much. I had a quick search on these forums to see if I could find any similar threads.

Many thanks

Mark

2 REPLIES
Enthusiast

Re: Excel to Teradata Session logins

Mark,

You could make this work with Teradata Wallet.  Install TD Wallet on your pc and embed the TD wallet string in your odbc connection.  Your password stays protected, all that's exposed is the TD Wallet String side of the name/value pair stored by TD Wallet.

Cheers,

Blaine

Fan

Re: Excel to Teradata Session logins

Thanks Blaine, I will give this a try.

Mark