|
Connectivity | Welcome to the Teradata Forums.
Read the
guidelines on posting.
Email notifications and RSS feeds are available, and also a chronological list of all forum activity. |
|
20 Apr 2012
Seems like "tdload" does not support any kind of target "LogonMech" other than the default td2. Hence your ldap database access can't be used. IE Only a full tpt script will allow ldap authentication. You must sign in to leave a comment.
|
Active Topics Last 60 days
|
I am new to Teradata and was trying to setup something similar to sql loader to load delimited files into tables.
Below is the script i ran from my unix prompt.
tdload -c ASCII -j tdloadjobvars.txt
Below are the contents of my "tdloadjobvars.txt" file.
TargetLogonMech='ldap',
TargetLogonMechData='authcid=xxxx password=xxxx',
TargetTdpId='idwprd',
TargetWorkingDatabase = 'xxxx',
TargetUserName='xxxx',
TargetUserPassword='xxxx',
SourceFileName = 'tdload.csv',
TargetTable = 'tdload_1',
SourceTextDelimiter = ',',
TargetMaxSessions = 5
I am getting the following error message.
Teradata Load Utility Version 13.00.00.12
Got RDBMS Error 8017: The UserId, Password or Account is invalid.
I can logon using BTEQ and FASTLOAD utility.
Can anyone help?