Need technical support in decryption of a columns in Vertica DB through any supporting client tools
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 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.