All Forums Connectivity
TSchmolzi 30 posts Joined 07/07
19 Mar 2012
JDBC Encryption

I have a couple application are are using ENCRYPTION=ON in their connection strings.  Is there any way to tell on the database side (DBQL, etc) so that I may verify that the encryption parameters are being accepted?

- Tim S

tomnolan 594 posts Joined 01/08
19 Mar 2012

The connection parameter is actually ENCRYPTDATA=ON

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#URL_ENCRYPTDATA

Sorry, No, there is no way to tell on the database side that encryption is in use.

The Teradata JDBC Driver's debug log output (connection parameter LOG=DEBUG) will indicate whether network data encryption is used, but that is on the client side, not the database side.

TSchmolzi 30 posts Joined 07/07
19 Mar 2012

So I basically just have to "trust" that the encryption is working?

Thanks for the info on the LOG=DEBUG argument. I'll give that a shot. 

- Tim S

tomnolan 594 posts Joined 01/08
19 Mar 2012

>>> So I basically just have to "trust" that the encryption is working?

I agree that it ought to work better. I expect this to improve in a future version.

Some customers need a way to enforce that all Teradata sessions are using encryption; for HIPAA compliance, for example. If that's your need, you should open a customer service incident and ask what your enforcement options are.

You must sign in to leave a comment.