Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

AES256 encryption algorithm: Custom SQL function in Adobe Campaign

iambhosale
Level 3
Level 3

Hi Please help me with approach for below implementation.

Adobe Campaign by default does not support all the functions residing in the underlying PostgreSQL database.

Add a custom function to encrypt the input string using AES256 encryption algorithm. PostgreSQL supports this algorithm natively.

You will need to add a new category (‘CC Custom Functions’) and a new function (‘AES Encrypt’) to right-side list of functions of the Advanced Query window.

Configure the input parameters and key values accordingly. Please refer the documentation for more details (the exact steps to add a new custom function are mentioned there).

0 Replies