Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 18 Jul 2011 @ 09:19:39 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Data encryption using TPT
 
From:   Badnikar, Amogh

Hi,

At one of my clients, I am using tpt to load data from oracle to Teradata. There is a need to encrypt some sensitive data. I tried setting DataEncryption attribute but it doesn't actually encrypt the data in the table. I think the data is encrypted only during transmission.

Has anyone used DataEncryption in apply statement? Is there a way to encrypt the data in tpt without using udf.

     DEFINE OPERATOR UPDATE_OPERATOR
        DESCRIPTION 'UPDATE OPERATOR'
        TYPE UPDATE
        SCHEMA TEST_TPT_SOURCE_SCHEMA
        ATTRIBUTES
        (
           VARCHAR PrivateLogName = 'D2DCFT_STG_CAN.log',
           VARCHAR PauseAcq ,
           INTEGER ErrorLimit,
           INTEGER BufferSizes,
           INTEGER TenacityHours,
           INTEGER TenacitySleep,
           INTEGER MaxSessions,
           INTEGER MinSessions,
           INTEGER RowInteval,
           VARCHAR DataEncryption = 'ON',
           VARCHAR TdpID        = 'xxxxxxxx',
           VARCHAR UserName     = 'xxxxxx',
           VARCHAR UserPassword = 'xxxxxx',
           VARCHAR AccountID,
           VARCHAR TargetTable  = 'D2DCFT_STG_CAN.TeradataTarget',
           VARCHAR ErrorTable1  = 'D2DCFT_WRK.TeradataTarget_e1',
           VARCHAR ErrorTable2  = 'D2DCFT_WRK.TeradataTarget_uv',
           VARCHAR WorkTable    = 'D2DCFT_WRK.TeradataTarget_wt',
           VARCHAR LogTable     = 'D2DCFT_WRK.TeradataTarget_log',
           VARCHAR WorkingDatabase = 'D2DCFT_WRK'
        );

Any feedback would be helpful


Regards,

Amogh Badnikar



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016