Archives of the TeradataForum

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

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

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>>