I'm investigating the ability to mask data using Golden Gate.
We would like to create mirror copy of a source production, and have a masked/mirror copy of that database (non-production).
With Golden Gate masking the database before it applied to the mirror database.
We would then use this masked mirror of production as a source for development environments.
Has anyone set up a similar use case? If so can you provide examples, or a reference.
We are looking at using USER EXIT to call C code which would take data and mask. The data would still need to be in a valid format for the data type. For example SSN.
By using the C code, we hope to write the transformation/mask once, then deploy the same mask in SQL Server, Oracle, and DB2 environment.
Requirements:
1. Mask data consistently for Oracle, SQL Server and DB2 databases.
This is so that applications that cross databases could still reference each other.
2. Be near real time. Accepting a delay of a few minute/hours if the days change volume is heavy.
Any advice, director or help would be appreciated.
Thank you.