masking and unmasking data

[Anonymous]

experts advise needed.

I have some talend jobs which loads customer details in postgresql db. now, we need to mask some columns due to the privacy purpose.

- is it possible to mask the data in talend and insert into postgres table if yes then how to unmask the data to see original ( let say i have two different types of users in postgres mask_user, unmask_user based on their role they can see the data using select query)

[manodwhb · Accepted solution]

@prithivt, check for the tDatamasking or tDataencrption components available , will work for you requirements. 

https://help.talend.com/reader/0o9b5oCDP162lzXURYPZbg/R1NAC2Od5m9jbwXnQCDjKw