Provisioning Omada Identity Suite Data for Development and Test?
Hi,
I naively said recently that a customer of mine could use SQL Clone/Provision in order to provide PROD-like Data anonymised/cleaned for Dev, Test, and Acceptance Testing. However, a closer look at teh data "structure" within the Omada Product will mean that an anonymiser routine would have its work cut out, having to make correlated changes in standard and XML fields.
Is there any experience of anyone doing this?
Many thanks for any input, positive or negative,
Andrew
Tagged:
Best Answer
-
PlantBasedSQL
Posts: 187 Gold 4
Thank you for clarifying @AndrewC
That makes sense - so in either case we are able to mask the XML, however obviously the second scenario is considerably simpler and involves using an XML masking rule in Data Masker.
For the first scenario i described and the one you mentioned, the solution would be to use a Synchronisation manager rule, i.e. take a substitution rule that is masking a regular column (one that also appears in the XML) and then convert it into a sync manager, using a Table-To-Text rule to then sync the same value across both the regular column and the XML.
You can find more information on the Sync Manager rule here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/how-do-i-synchronize-changes-to-an-item-with-no-logical-join
But if you need further information on this please feel free to let me know!
Thank you very much.
Answers
By correlated changes do you mean, for example, having a FirstName column, LastName column and an XML field in which FirstName and LastName both exist and you need to sync the masking internally to the XML as a result of what the FirstName and LastName get masked to in the separate columns?
Or do you mean that you just need something that is capable of masking both standard fields and also XML fields?
Thank you very much.
I'm only starting to get into the Omada Infrastructure so my understanding might be incomplete but yes, your first scenario is the kind of thing I am told we are looking at. There are further complications but I want to cross each bridge one at a time.