Comments
Sort by recent activity
Hi, To continue on the accepted answer of this question. I want to do the same. Each table in our database has the fields CreatedBy and ModifiedBy (nvarchar fields), I want to mask that.
I have more then 80 tables in the database, so taking the first option, it will generate 80 internal-row rules. I have two fields to mask this way, so 160 rules. Can we group these rules so that we can collapse these rule into one line? It is easier to manage and to retain the overview of the rules. Not able to do the grouping, I did take the second option: creating a normal substitute rule and then convert it to a sync rule. A sync rule is collapsible, so I retains my overview. But in my substitute rule I had a Where clause: replace only if the text is an email address (the text can also be a name of a automatic tool that I don't want to mask)
How to do that in a sync rule? / comments
Hi,To continue on the accepted answer of this question.I want to do the same. Each table in our database has the fields CreatedBy and ModifiedBy (nvarchar fields), I want to mask that.
I have more ...
To answer my own question.
Via a work-around we can group these rules : take the first rule and drag and drop all the other under this rule. But than you change the dependency...
There is no where clause in a sync rule, so you must do it in the resulting Table-To-Table rule for each table.
Pay attention in the current version 7.0.4.5445 of Data Masker when writing your where clause. It must contain the alias for the target table, not only the fieldname or you will get an ambiguous fieldname error.
Example : where DMTGT.CreatedBy LIKE '%_@__%.__%'
DMSRC: the source table
DMTGT: the target table
/ comments
To answer my own question.
Via a work-around we can group these rules : take the first rule and drag and drop all the other under this rule. But than you change the dependency...
There is no where ...