A client requires that they use oracle vault to encrypt their data. How will Netezza deal with this ?
Netezza supports a number of encryption and decryption keys. The Netezza SQL Toolkit PDF indicates those supported through decode and encode.
“You can choose which symmetric encryption algorithm the function uses to encrypt/decrypt the data, either AES (Advanced Encryption Standard) or RC4.”
Note should be made that this is at field level encryption and not database level encryption. The question then is if using oracle vault to encode the data, what can be used to decode it from the database ?
There is obviously a requirement to know the decrypyion key to decode the data once it’s in the database. But it should be standard, therefore the same key on the oracle database can be used in the Netezza System.
I’ll update this with an example once I get the chance or a working example.
