Encrypt data | Community
Skip to main content
Level 2
October 28, 2021
Solved

Encrypt data

  • October 28, 2021
  • 2 replies
  • 3041 views

Hello everyone,

I was wondering if there's any function that we can use to encrypt data, for instance an email of a client in the enrichment box.

 

Thank you.

 

Best regards

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Malarrajan_Sundar

Hi @ofattah ,

1.Cretae sql function based on the configured database(Postgres,Oracle..etc) to encrypt/decrypt the string.

2. Using javascript call the function to encrypt/decrypt the string.

var encrypt = sqlGetString('select encrypt($(sz))', email);

 

Regards,

Malarrajan Sundarraj

 

 

2 replies

Malarrajan_SundarAdobe EmployeeAccepted solution
Adobe Employee
October 28, 2021

Hi @ofattah ,

1.Cretae sql function based on the configured database(Postgres,Oracle..etc) to encrypt/decrypt the string.

2. Using javascript call the function to encrypt/decrypt the string.

var encrypt = sqlGetString('select encrypt($(sz))', email);

 

Regards,

Malarrajan Sundarraj

 

 

OfattahAuthor
Level 2
October 28, 2021

Hi @malarrajan_sundar 

 

Thank you for your response.

Is there any built-in function that we can use in the enrichment box to encrypt whatever fields we want please?

I found this function :

encryption_aescbcEncrypt

but it's usable only on Adobe campaign standard, I need a function that we can use in the enrichment box on Adobe Campaign Classic.

 

Thanks

 

Best regards

Sukrity_Wadhwa
Community Manager
Community Manager
November 1, 2021

Hi @malarrajan_sundar,

Could you please help @ofattah further here?

Thanks!

Sukrity Wadhwa