JDBC Encryption

[TSchmolzi]

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?

[tomnolan]

The connection parameter is actually ENCRYPTDATA=ON

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

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]

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. 

[tomnolan]

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