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 Postgres Target.

Environment

Local Data Processing

Overview:

This can be achieved by using the Postgres database’s inbuilt replace function in the IntegrateExpression. For example, if you would like to mask string A1234 to XXXX on Postgres:

1. Add 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.