About Sync Table to Table Rule

• 
  Hi bcnk thank you for your question!
  
  Unfortunately there's no multi-fan out available from a Table To Table rule within Data Masker at the moment and this would be handled by creating multiple T2T rules within your masking set.
  
  That being said, if it is a large amount of tables and you would like them to be more easily handled then you might be able to use a Synchronisation Manager rule (instructions here, don't mind the PKFK references) which would allow you to mask all distinct values across the affected tables and fan them out within a single rule, which may be easier.
  
  Let me know if you have any follow up questions or if there's anything else I can help out with!
  
  Kindest

  PlantBasedSQL January 07, 2021 08:32

  - 0 +
• 
  Hi lantBasedSQL ,     I will look into the Synch Manager Rule.  thank you so much for your response    (I am sure I 'll be having some questions about the rule  )  Thanks ! 

  bcnk January 07, 2021 13:07

  - 0 +
• 
  Hi lantBasedSQL ,     I will look into the Synch Manager Rule.  thank you so much for your response    (I am sure I 'll be having some questions about the rule  )  Thanks ! 

  bcnk January 08, 2021 09:09

  - 0 +
• 
  HI PlantBasedSQL,  I tried the Sync Manager .  I used Customer ID from DM_CUSTOMER , DM_CUSTOMER NOTES and DM_CUSTOMER_ASXML_IDAttr.   It seems like DM_CUSTOMER and DM_CUSTOMER NOTES 's Customer IDs synched with new Customer ID numbers but for DMC_CUSTOMER_ASXML_IDAttr, I could not find the synched numbers.  (It did change from original Customer ID numbers to new numbers).   Can you tell me what I missed with the rules? 
  Thank you,

  bcnk January 08, 2021 20:50

  - 0 +
• 
  Hi @bcnk thanks for coming back on this, I'm not sure I 100% understand,
  
  Do you mean you were able to mask Customer_ID on the DM_Customer and DM_Customer_Notes tables, but not on DM_CUSTOMER_ASXML_IDAttr?
  
  If so, instead of selecting Rule Generation by FK in the Sync Manager, you will need the Column option instead, and you can search for all columns called Customer_ID and add them manually.
  
  If you mean, you were unable to update the Customer_ID that is held WITHIN the XML itself in DM_CUSTOMER_ASXML_IDAttr then you will require a Table-To-Text rule within your Sync Manager, instructions here: https://www.red-gate.com/hub/university/courses/data-masker/advanced-operations-with-data-masker/advanced-operations-with-data-masker/synchronizing-into-xml-and-json
  
  Let me know hoe you get on! Thank you very much.
  
  Kindest

  PlantBasedSQL January 11, 2021 09:07

  - 0 +
• 
  Thank you,  I will look into the Column option in our Database.       Thank you for your replies and support

  bcnk January 13, 2021 14:27

  - 0 +
• 
  My pleasure @bcnk let me know how you get on!

  PlantBasedSQL January 13, 2021 14:42

  - 0 +

Add comment

Please sign in to leave a comment.