All Forums Database
dins2k2 51 posts Joined 05/13
21 Jan 2015
Encryption in Teradata

Hi All,
How encryption happens in Teradata? What are the different levels of encryption defined in Teradata? And of course decryption too.
Thanks,
Dinesh

Raja_KT 1246 posts Joined 07/09
21 Jan 2015

Encryption can be when you do backup to tapes....
You can develop UDFs as per your requirement too. There are tools available , working along with teradata and  hadoop too. 
For client say for eg ,when you use tpt  you can add DataEncryption = 'ON'
odbc configuration:

 

When Enable Data Encryption is checked – the option directs the ODBC Driver to use Data Encryption, causing ODBC Driver for Teradata and Teradata Database to communicate with each other in encrypted manner.

When Enable Data Encryption is cleared–Data Encryption is disabled.

Try to check TeraGSS.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dins2k2 51 posts Joined 05/13
23 Jan 2015

Thanks for the info Raja.
So, Teradata doesn't have any inbuilt encryption mechanism to protect the data? Like storing the row values in tables with encrypted form. I have seen few UDFs for encrypting the data while storing in table.
Thanks,
Dinesh

Raja_KT 1246 posts Joined 07/09
23 Jan 2015

It has. You can go through this link and see FDE. I thin this is what you are looking for.
 http://www.info.teradata.com/edownload.cfm?itemid=140900012
It is chapter 9, where you can see password, message..... FDE
Also in-flight encryption and decryption is safe as I highligted above.
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Tuen 44 posts Joined 07/05
24 Jan 2015

If your asking if Teradata has native functions to provide data encryption outside of the password fields in DBC and a few other system tables, then the answer is no.  Generally, you would have to go with a 3rd party tool to provide data at rest encrpyption, or as Raja mentions build your own UDF's to do something of that nature.  Teradata's client utilities do provide over the wire encryption as mentioned above.  

dins2k2 51 posts Joined 05/13
27 Feb 2015

Thanks Raja and Tuen.

You must sign in to leave a comment.