Redgate Test Data Manager

Combining options files

Separate options files can be used for each step of the anonymization process, as shown so far in this worked example.

However, it is possible to combine all of the options together into one file. This enables the same options file to be used for each of the classify, map and mask steps. Any bits of the options file that don't apply to that step are ignored.

  1. {
  2. "classifications": {
  3. "builtIn": {
  4. "enabled": [
  5. "FullNames"
  6. ],
  7. "disabled": [
  8. "Cities",
  9. "Countries",
  10. "CreditCardNumbers",
  11. "DatesOfBirth",
  12. "EmailAddresses",
  13. "FamilyNames",
  14. "GivenNames",
  15. "IPAddresses",
  16. "PassportNumbers",
  17. "PhoneNumbers",
  18. "PostCodes",
  19. "StreetAddresses",
  20. "UKCounties",
  21. "UKNationalInsuranceNumbers",
  22. "USSocialSecurityNumbers",
  23. "ZipCodes"
  24. ]
  25. },
  26. "custom": [
  27. {
  28. "type": "CompanyNames",
  29. "confidence": "High",
  30. "condition": "Column.Name contains 'Company' AND Column.Name contains 'Name'"
  31. }
  32. ]
  33. },
  34. "tables": [
  35. {
  36. "schema": "dbo",
  37. "name": "CustomerDemographics",
  38. "exclude": true
  39. },
  40. {
  41. "schema": "dbo",
  42. "name": "Shippers",
  43. "columns": [
  44. {
  45. "name": "Phone",
  46. "exclude": true
  47. }
  48. ]
  49. },
  50. {
  51. "schema": "dbo",
  52. "name": "Suppliers",
  53. "columns": [
  54. {
  55. "name": "ContactName",
  56. "type": "FamilyNames"
  57. },
  58. {
  59. "name": "ContactTitle",
  60. "dataset": "JobTitles"
  61. },
  62. {
  63. "name": "HomePage",
  64. "type": "Websites",
  65. "preserveNulls": true,
  66. "maxLength": 20
  67. }
  68. ]
  69. },
  70. {
  71. "schema": "dbo",
  72. "name": "Territories",
  73. "columns": [
  74. {
  75. "name": "TerritoryDescription",
  76. "dataset": "Cities"
  77. }
  78. ]
  79. }
  80. ],
  81. "datasets": [
  82. {
  83. "name": "CompanyNames",
  84. "type": "List",
  85. "values": [
  86. "Redgate Software",
  87. "Microsoft",
  88. "Google",
  89. "Amazon",
  90. "Apple",
  91. "Facebook",
  92. "Twitter"
  93. ]
  94. },
  95. {
  96. "name": "JobTitles",
  97. "type": "List",
  98. "values": [
  99. "CEO",
  100. "CTO",
  101. "Director",
  102. "Engineer",
  103. "Developer",
  104. "Designer",
  105. "Analyst",
  106. "Consultant"
  107. ]
  108. },
  109. {
  110. "name": "Websites",
  111. "type": "List",
  112. "values": [
  113. "https://www.example.com",
  114. "https://www.test.com",
  115. "https://www.google.com"
  116. ]
  117. }
  118. ],
  119. "settings": {
  120. "dateTimeFormats": [
  121. "YYYY-MM-dd",
  122. "yyyy-mm-dd HH:mm:ss"
  123. ]
  124. }
  125. }

Lines 2-49 show the configuration from the classification-options.json file.

Lines 54-61 show the configuration from the mapping-options.json file.

Lines 62-67 show the configuration from the classification-options.json file.

Lines 70-79 show the configuration from the masking-options.json file.

Lines 82-108 show the configuration from the mapping-options.json file.

Lines 109-124 show the configuration from the masking-options.json file.


Didn't find what you were looking for?