QUESTION:
How are encrypted fields handled by PeopleImport?
ANSWER:
- Matching on encrypted fields:
- Users that have the "View Encrypted Data" permission on their Salesforce profile will be able to use an encrypted field in their matching.
- Using Encrypted Fields in a Where Clause:
- Encrypted fields CANNOT be used in where clauses, i.e. cannot be filtered on, regardless of having "View Encrypted Data" permission.
- Note: This is NOT unique to PeopleImport, you will have the same problem attempting to filter on encrypted fields in the Salesforce Data Loader and elsewhere.
- Encrypted fields CANNOT be used in where clauses, i.e. cannot be filtered on, regardless of having "View Encrypted Data" permission.
Note: User may also want to review the following solution: Are Validity Tools compatible with Shield Platform Encryption?
***Below is information on encrypted field use for clients also using DemandTools and DupeBlocker***
- Matching on encrypted fields:
- DemandTools
- Users that have the "View Encrypted Data" permission on their Salesforce profile will be able to use an encrypted field in their matching.
- Depending on the mask chosen for the encrypted field, other users may be able to select the encrypted field for matching.
- DemandTools analyses the mask NOT the data behind the mask, if the enitre field is masked, every record with this field populated with the same number of characters will be returned as a match .
- DupeBlocker
- DupeBlocker can match on fields that are encrypted.
- The duplicate key has the actual data in it vs. the encrypted data.
- The key field in DupeBlocker Potential Duplicate records will show the data, and it will not be encrypted in the key.
- Since the key is a required field on the DupeBlocker Potential Duplicate object there is no way to control the value entered into the key field.
- The Duplicate Key field can be hidden using field level security.
- DemandTools
- Using Encrypted Fields in a Where Clause:
- DemandTools
- Encrypted fields CANNOT be used in where clauses, i.e. cannot be filtered on, regardless of having "View Encrypted Data" permission.
- Note: This is NOT unique to DemandTools, you will have the same problem attempting to filter on encrypted fields in the Salesforce Data Loader and elsewhere.
- Encrypted fields CANNOT be used in where clauses, i.e. cannot be filtered on, regardless of having "View Encrypted Data" permission.
- DemandTools
- Updating a Field with Data from an Encrypted Field:
- DemandTools
- ONLY users with "View Encrypted Data" should attempt to update a field with data directly from an encrypted field (i.e. MassImpact "Update Value" using the "Field Tab"), otherwise the mask characters will be populated in the field being updated vs. the actual data.
- DemandTools