Fastload LDAP

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
New Member

Fastload LDAP

Hello,

 

I am very new to Teradata. Hopefully, I am asking write question in the forum. :)

 

I have written fastload script that works absolutely on the local machine but fails to authenticate on the main environments.

The main environments uses LDAP authentication. I have used "logmech ldap" in my script but it still doesn't work. Please see below the script I am trying to run:

 

Error Message: Invalid username password.

 

SCRIPT:

 

logmech ldap;

LOGON server/dbc,"dbc";  
DATABASE DemoDB;

CREATE TABLE SALES3
,FALLBACK
,NO BEFORE JOURNAL
,NO AFTER JOURNAL
(
   ID     VARCHAR(50) TITLE 'ID' NULL
   , BatchId BIGINT TITLE 'BatchId' NULL
   ,CREATED     DATE TITLE 'Created On' NULL
    ,COL0     VARCHAR(50) TITLE 'COL0' NULL
    ,COL1     VARCHAR(50) TITLE 'COL1' NULL
    ,COL2     VARCHAR(50) TITLE 'COL2' NULL
    ,COL3     VARCHAR(50) TITLE 'COL3' NULL
    ,COL4     VARCHAR(50) TITLE 'COL4' NULL
    ,COL5     VARCHAR(50) TITLE 'COL5' NULL
    ,COL6     VARCHAR(50) TITLE 'COL6' NULL
    ,COL7     VARCHAR(50) TITLE 'COL7' NULL
    ,COL8     VARCHAR(50) TITLE 'COL8' NULL
    ,COL9     VARCHAR(50) TITLE 'COL9' NULL
);
   
BEGIN LOADING DemoDB.SALES3  
ERRORFILES SALES3_ET, SALES3_UV  
CHECKPOINT 100000;  
SET RECORD VARTEXT '≡';

      DEFINE
         "COL0" (VARCHAR(50)),
         "COL1" (VARCHAR(50)),
         "COL2" (VARCHAR(50)),
         "COL3" (VARCHAR(50)),
         "COL4" (VARCHAR(50)),
         "COL5" (VARCHAR(50)),
         "COL6" (VARCHAR(50)),
         "COL7" (VARCHAR(50)),
         "COL8" (VARCHAR(50)),
         "COL9" (VARCHAR(50)),
         "ID" (VARCHAR(50)),
         FILE = 'D:\test.csv';
          INSERT INTO DemoDB.SALES3 (
            BatchId,
            "COL0",
            "COL1",
            "COL2",
            "COL3",
            "COL4",
            "COL5",
            "COL6",
            "COL7",
            "COL8",
            "COL9",
            "ID"
          )
        VALUES (
            10049,    
         :"COL0",
        :"COL1",
        :"COL2",
        :"COL3",
        :"COL4",
        :"COL5",
        :"COL6",
        :"COL7",
        :"COL8",
        :"COL9",
        :"ID"        
      );

   END LOADING;  
LOGOFF;

 

Please help me understand what additional commands/info is needed to run this script using LDAP authentication.

 

Thanks & Regards,

Mayur

  • Fastload
  • Ldap