How to mask data in BIX extract in csv format
Hi,
We have requirement to mask PII data in BIX extract which is in csv format.
How to accomplish this requirement? Please suggest.
JPMorgan Chase
IN
Morgan Stanley
US
@SriHarsha Anika The major question is how to encrypt data which is extracted by BIX rule using pxExtractDataWithArgs activity in job scheduler?
The data itself is extracted by BIX rule and exported on location.
JPMorgan Chase
IN
BIX doesn't have a feature to encrypt the csv/xml output file.
You can look at field level encryption using TextEncrypted properties or architect an alternative solution such as:
- outputting directly to a secure database, eliminating the need to encrypt files
- perform some lower level filesystem encryption, if your on-prem infrastructure supports this
- manually encrypt the unencrypted BIX export file with help of file listener, activity and cleanup of unencrypted file.
@RamKS157
Hi Ram,
There is not OOTB solution exist. You have to put down your own JOB scheduler which will extract data, encrypt it with a predefined key, and then write the content into CSV.