Sign in to Community
Sign in to view all badges
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).