All Teradata PT operators that interface with the 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 database. Encryption is only available for workstation-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 can 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.