How to Decrypt fields for an entire table at once?
Hello, We get a client’s data each week and we try to encrypt the data using encrypt snap and Keystore account. Next, for decryption, we save the encrypted fields for each file into a separate file and append the encrypted new weekly data to the historical table. There’s a huge problem, when we have to decrypt. Since we have encrypted fields saved in a separate file for each weekly file, we can’t decrypt the entire historical table at once for that client. The goal is to have a way be able to decrypt the entire table as and when we need it. Here’s how it looks now:
Encrypt and decrypt sensitive data in a source
Created by @pavan This pipeline pattern will encrypt fields passed as JSON docs using a defined transform type (AES), and decrypts and gives back the original message. This pattern is useful for encrypting sensitive messages (credit card info, SSN, patients name, DOB etc). Configuration Within the JSON Generator, replace “Enter certificate here” with your own certificate. Sources: JSON Targets: JSON Snaps used: JSON Generator, Encrypt Field, Mapper, Decrypt Field Downloads Encrypt & Decrypt Fields.slp (9.1 KB)