Run mapping

With the mapping-options.json file now created, the mapping step can be ran to create a masking file.

rganonymize map
  --options-file mapping-options.json
  --classification-file classification.json
  --masking-file masking.json

This takes the mapping-options.json and classification.json files as input, maps the classifications to the relevant masking rules, and outputs a masking.json file:

{
  "tables": [
    {
      "schema": "dbo",
      "name": "Customers",
      "columns": [
        {
          "name": "CompanyName",
          "dataset": "CompanyNames",
          "maxLength": 40
        },
        {
          "name": "ContactName",
          "dataset": "FullNames",
          "deterministic": true,
          "maxLength": 30
        }
      ]
    },
    {
      "schema": "dbo",
      "name": "Shippers",
      "columns": [
        {
          "name": "CompanyName",
          "dataset": "CompanyNames",
          "maxLength": 40
        }
      ]
    },
    {
      "schema": "dbo",
      "name": "Suppliers",
      "columns": [
        {
          "name": "CompanyName",
          "dataset": "CompanyNames",
          "maxLength": 40
        },
        {
          "name": "ContactName",
          "dataset": "FamilyNames",
          "deterministic": true,
          "maxLength": 30
        },
        {
          "name": "HomePage",
          "dataset": "Websites",
          "preserveNulls": true,
          "maxLength": 20
        },
        {
          "name": "ContactTitle",
          "dataset": "JobTitles"
        }
      ]
    }
  ],
  "datasets": [
    {
      "name": "JobTitles",
      "type": "List",
      "values": [ "CEO", "CTO", "Director", "Engineer", "Developer", "Designer", "Analyst", "Consultant" ]
    },
    {
      "name": "CompanyNames",
      "type": "List",
      "values": [ "Redgate Software", "Microsoft", "Google", "Amazon", "Apple", "Facebook", "Twitter" ]
    }
  ]
}

Lines 3-30 show the mapping from the classification file.

Lines 35-39 show the mapping from the classification file.

Lines 40-45 show the corrected classification for the ContactName column of the dbo.Suppliers (A).

Lines 46-51 show the mapping from the classification file.

Lines 52-55 show the custom masking (B).

Lines 60-69 show the custom datasets (C).



Didn't find what you were looking for?