How To Mask String in a Column Value in PostgreSQL Target
Introduction
There are situations when you may prefer not to make the password visible to the end users. Below, find out how to mask a string in a column value in a PostgreSQL Target.
Environment
HVR 5
Overview:
This can be achieved by using the PostgreSQL database’s inbuilt replace function in the IntegrateExpression. For example, if you would like to mask string A1234
to XXXX
in PostgreSQL:
Add the below IntegrateExpression to the Target Group.
ColumnProperties /Name=c2 /IntegrateExpression="replace ({c2},'A1234','XXXX')"
Note:
c2
is the column name.Initialize the channel with scripts and jobs.