I have a spreadsheet that pulls back multiple tables from Teradata using the Data connection tool within Excel 2010.
My issue is Excel is requesting me to type my Teradata password in for every table/query bought back/that runs (username is saved).
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.
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.