To run database archive script with integrated security

Tools & Utilities

To run database archive script with integrated security

I'd like to archive all databases on Teradata for Windows, with following logon script, we can successfully logon and perform further archive action easily.

LOGON tdpid/user,password;
ARCHIVE DATA TABLES (DBC) ALL,
RELEASE LOCK, INDEXES,
OUTPUT ROW COUNT, FILE = archive;
LOGOFF;

But the question is how to take advantage of SSO to do the job instead? I changed the logon statement to "LOGON tdpid/,;" , but it always popup logon window.

thanks
Rock
1 REPLY

Re: To run database archive script with integrated security

To reveal DBC password in the script should not be a good practice, does anyone has same requirement here?