Question
Coforge Technologies (Erstwhile Incessant Technologies)
GB
Last activity: 16 Oct 2018 12:03 EDT
Does Elastic Search supports Encrypted Column data
We have recently implemented encryption on few properties whose data is stored in encrypted format in database. Since then, Search functionality is not working on those columns data content. Is there any hotfix or workaround available for this.
***Moderator Edit: Vidyaranjan | Updated Categories & SR details***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
IN
Further more, there is no special setting for searching on encrypted vs decrypted value.
Elastic search would store information as is that is returned by the Clipboard Page. So, when the developer does an Obj-Open on the object, whatever the value is displayed on the Clipboard Page for the user, would be stored.
Pegasystems Inc.
IN
Hello Praveen,
Thanks for posting your query in PSC :)
I see that you have raised SR-B54431 with the same query.
Regards,
Rincy
Pegasystems Inc.
AU
Hi Praveen,
I have reviewed the documents for the guides available on the elastic co web page, could not find much information about supporting search for the encrypted columns. There is a configuration for the fuzzy search you can refer to the pdn article https://community.pega.com/sites/default/files/help_v722/procomhelpmain.htm let me know if it helps.
Regards,
Basavaraj Kadakol
Pegasystems Inc.
IN
Hello Praveen,
Good Morning!!
As per our product specialist, whatever value is there in BLOB would be stored in Elastic Search and is used for content search. So, while doing content search on encrypted property, are you trying to search with encrypted or normal value?
Regards,
Rincy
Accepted Solution
Pegasystems Inc.
IN
Further more, there is no special setting for searching on encrypted vs decrypted value.
Elastic search would store information as is that is returned by the Clipboard Page. So, when the developer does an Obj-Open on the object, whatever the value is displayed on the Clipboard Page for the user, would be stored.
Pegasystems Inc.
FR
Hi,
I have the same question here for a prospect, but I don't understand the answer.
Does it mean that for cases with "encrypted blob" enabled, the corresponding index data in Elastic Search is stored decrypted? Or does it depend on the access right of the latest user who has done an Obj-Open on the object? How are the access rights managed on the search? If I have no right to decrypt the case, I don't have the corresponding search results?
If you have the name of the product specialist, could you please send it to me?
Thanks in advance,
Best regards,
Stéphanie Barreau