How To Mask String in a Column Value in PostgreSQL Target

Question

I don't want to make a password visible to the end users. How can I mask a string in a column value in a PostgreSQL Target?

Environment

• HVR 5
• Target: PostgreSQL

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.