You can translate the question and the replies:

Run encrypt function in SQL statement

Can Denodo can make SQL calls from the source database via JDBC by encrypting the result from the source database. The issue is that we have PII and PHI data that is being called from the source database in MySQL and the data is passed through Denodo and extracted from a Web Service. Due to the sensitive nature of the data we need to have it encrypted.
encrypt
user
24-07-2018 16:19:07 -0400
code

3 Answers

Hi, I’m not sure if this is something you should or want to be doing through individual SQL statements. If you need the data to be encrypted as it travels through your networks, that’s what SSL is for. Details can be found [here](https://community.denodo.com/docs/html/browse/6.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/enabling_ssl_in_denodo_platform_servers). If you need additional protection for who can see what sensitive data, we have column level security available in Denodo. This can mask or withhold the sensitive data, and is enforced within the query engine. Some details regarding those features can be found [here](https://community.denodo.com/answers/question/details?questionId=90670000000XcxvAAC&title=Encryption+and+Decryption+in+Denodo), and column level security can be set up under “advanced privileges” in role management. Hope this helps!
Denodo Team
25-07-2018 19:34:24 -0400
code
Is there code such as a Stored Procedure or a User Defined function that we can get from Denodo to complile, use and call in the code.
user
02-08-2018 18:06:47 -0400
Hi, You can find info on extra encryption functions [here](https://community.denodo.com/answers/question/details?questionId=90670000000CdMnAAK&title=Encryption+and+decryption), but you will need a support user in your organization in order to access the Denodo Xtrafuncs for VDP package on the support site. Instructions for how to use them are included in the file. Hope this helps!
Denodo Team
14-08-2018 14:55:57 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here