Data Masking
Quick Start with DBSync Replication Data Masking
Whenever there is a need to copy the data from one Salesforce account to another, the user might want to mask the data for specific objects to safeguard the sensitive information.
With this feature, the user can mask the necessary objects before copying the data to another. Use DBSync Replication with source app Salesforce to connect a database.
(Note: Source App includes only Salesforce CRM Application)
The DBSync replication is offering you to connect the source app like Salesforce with different databases like MySql, SQL Server, Oracle, DB2, PostgreSQL, Cassandra, Redshift, Sybase, Snowflakes, and MongoDB.
Log in to the DBSync replication portal
Sign in to the DBSync Replication portal.
Steps to Follow
Here are some steps that you have to follow to start the Data Masking. Once you have a login to the DBSync replication portal you have to follow these below steps.
Click to "add profile" in the right-hand corner of the profiles section of the DBSync replication portal.
Select, the required source name application from the drop-down menu under the product header.
Next, enter the name of the profile like "test profile" under the name section.
Click to "Salesforce setup tab on the left-hand corner in the profiles section of the DBSync Replication portal.
Don't change the "environment and soap end details", all these details are pre-filled.
Once completed, click on the next button to proceed to the database setup tab.
Click to "database" setup tab on the left-hand corner in the profiles section of the DBSync replication portal.
Select, the required "type name" from the drop-down menu options like "MySql, SQL Server, Oracle, DB, PostgreSQL, Cassandra, Redshift, Sybase, Snowflakes, AWS S3 and MongoDB" under the "database setup" section.
Once, this is done click on the save button and test the connection.
Click on the next button to redirect to the object page, their user has to select the particular Object which he/she wants to do the Data Masking.
Once, you have selected the Object- Account then click on the Run button to select any command like Cleancopy and wait for the sync.
Once, the Sync is complete then the user has to go back to Export Tab, select the Object from the Schema and click on the run button and select the column in which you want to change.
As you can see on the above image Account object is showing on the top left corner and other options like Mask Enabled (Toggle buttons), Column, and Mask Type.
Here, I have selected the Phone Column and enabled the mask. On the right side, you will see the drop-down menu to select the mask type.
These are the six Mask type we support for data maskings like Date/Time, Phone Mask, Email Mask, Default Mask, Rando Mask, and Credit Card Mask.
After the changes click on the Export Tab to move further.
Once you have clicked on the export button it will pop-up a Source Metadata window. Select the Object - Account and click on the Next button.
It will redirect to the Target Profile pop-up, their user has to select the existing profile or create a profile section in which the user has to give the target Salesforce credentials.
Once it is connected with the Target Salesforce then click on next to validate the data and finish the export task.
As you can see on the above image first 5 digits have been masked and the last 5 digits are visible only. This means data was masked successfully.
Last updated