How To Mask String in a Column Value in PostgreSQL Target

Question

There are situations when I may prefer not to make the password visible to the end users. How can I mask a string in a column value in a PostgreSQL target?

Environment

HVR 6

Answer

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:

1. Add the below IntegrateExpression to the Target Group.

   ColumnProperties /Name=c2 /IntegrateExpression="replace ({c2},'A1234','XXXX')"

   Note: c2 is the column name.

2. Initialize the channel with scripts and Jobs.