Can I look for data types and mask across multiple tables?

jj1

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.

Eddie D

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
 

jj1

Thanks Eddie.  I will attempt to put your suggestion to work on our systems.