2 Replies Latest reply on Jun 21, 2018 6:49 AM by Decal

    ISM Field encryption questions

    Decal Apprentice

      Symmetrically encryption of data inISM database: a number of constraints have been found - I was wondering if anyone on the community has in-depth experience of encryption of fields perhaps. Logged a support call and had a look in the community and helpfile but no answers forthcoming.

      These are:


      Unable to search on an encrypted field.

      Unable to do a full text search on an encrypted field.

      It is possible to set an encrypted field as sortable in a list, but the sort is done by the encrypted value and not the unencrypted value.
      It is possible to filter on an an encrypted field in a list, but the filter is done by the encrypted value and not the unencrypted value.

      Questions: SQL Report from outside of ISM-  is it possible to decrypt fields in reports? I know you can use encryption keys in each query.

      Example:

      Encypting Data:

      DECLARE @Result varbinary(256) SET @Result = EncryptByKey(Key_GUID('MySymmetricKeyName'), @ValueToEncrypt)

      Decrypting Data : You can decrypt data by using the DecryptByKey function, like so:

      DECLARE @Result varchar(max) SET @Result = DecryptByKey(@ValueToDecrypt)

       


      Can encryption be done via database stored procedures, which perform the encryption and decryption. Can ISM then interfaces with these stored procedures and write/read data to the DB?