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

Encrypt data

  • October 28, 2021
  • 2 replies
  • 3044 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

    M
    Adobe Employee
    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

     

     

      O
      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

        M
        Adobe Employee
        Malarrajan_SundarAdobe Employee
        Adobe Employee
        November 3, 2021

        Hi @ofattah ,

        Yes, encryption_aescbcEncrypt function usable only in ACS for encryption alone.

         

        We do have function in ACC as well.

        https://experienceleague.adobe.com/developer/campaign-api/api/f-cryptString.html

        But we cannot decrypt the string, because the function was deprecated.

         

        Better approach would be create SQL based encrypt/decrypt fucntion and can be used via JS/Enrichment box

         

        https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/api/adding-additional-sql-functions.html?lang=en

         

        Regards,

        Malarrajan Sundarraj

         

          O
          OfattahAuthor
          Level 2
          November 10, 2021

          Hi @malarrajan_sundar 

          Thank you for your help, 

          I will try your suggested solutions.

          Thanks

           

          Best regards

          Terms & ConditionsAccessibility statement

          Loading footer...