16.20 - Encryption - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

All Teradata PT operators that interface with the Teradata Database have the option to encrypt job data during transmission across the network. The data is then decrypted and checked for integrity when it is received by the Teradata Database. Encryption is only available for network-attached clients.

The following operators support data encryption:

  • DDL
  • Export
  • Load
  • SQL Inserter
  • SQL Selector
  • Stream
  • Update

Set the DataEncryption attribute to ‘On’ to enable encryption. The default setting is ‘Off.’ Encryption can also be set in an APPLY statement and as a job variable.

Encryption may result in a noticeable decrease in load/unload performance due to the time required to encrypt, decrypt, and verify the data, especially when the job involves the processing of very large quantities of data. Take care to encrypt data only when the security benefit is likely to outweigh the performance cost.