All Forums Third Party Software
MarkC 3 posts Joined 11/13
27 Mar 2014
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

VandeBergB 182 posts Joined 09/06
27 Mar 2014

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

Some drink from the fountain of knowledge, others just gargle.

MarkC 3 posts Joined 11/13
27 Mar 2014

Thanks Blaine, I will give this a try.
Mark

You must sign in to leave a comment.