Need technical support in decryption of a columns in Vertica DB through any supporting client tools

manju_raomanju_rao Registered User

Currently, we are loading the data to Vertica database through our internal ETL process and we are encrypting required columns using the encryption mechanism: AES-256-CBC with Message Digest SHA256 algorithm.

We need support to know if we there is a mechanism to get Decrypt data while data gets viewed in all Vertica database client tools (like Toad, DB Visualizer and other tools). Currently, we are connecting this Vertica Database using ODBC driver in Windows for your references.
Please help us to know your expertise suggestions and feedback for the same.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file