AES256 encryption algorithm: Custom SQL function in Adobe Campaign

Avatar

Avatar
Validate 1
Level 2
iambhosale
Level 2

Likes

6 likes

Total Posts

23 posts

Correct reply

7 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
iambhosale
Level 2

Likes

6 likes

Total Posts

23 posts

Correct reply

7 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
iambhosale
Level 2

21-05-2018

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).

Accepted Solutions (0)

Answers (0)