Can I look for data types and mask across multiple tables?
jj1
Posts: 3 New member
I have multiple databases based on a template database. Each table has some common columns and I don't look forward to setting up masking rules for each and every of the 30 databases.
Tagged:
Best Answer
-
Eddie D
Posts: 1,807 Rose Gold 5
Hi, thank you for your forum post.
Sadly I do not have a good answer to your question:
Can I look for data types and mask across multiple tables?
As both solutions will require some work.
Worst case scenario, Data Masker will require a Masking set for each database. You can create the first masking set on database_1. Make a copy and save as a different name, then edit the Rule Controller connection details to point to database_2 and then save the changes. Repeat for each database as required.
Alternatively, create the masking set on database_1 generating the substitution rules on the tables in database_1. Once you are happy with the rules created, next create Cross Database Table-to-table rules to then copy the masked data from database_1.Table1 to database_2.Table1 and so on. Make each Cross Database Table-to-table rule dependent on the substitution rule running against the table in Database_1.
Further information on Cross Database Table-to-table rules can be found here. Likewise information on setting rule dependencies are in this help article.
Many Thanks
Eddie
Answers