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:

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.