Data Masker Logo

[Net 2000 Ltd. Home][Data Masker Home][Data Masker Manual][Data Masker FAQ]

The Data Masker Datasets

Datasets provide data values for Insertion, Substitution and Row-Internal Synchronization rules. The datasets associated with the columns defined in the rule indicate which type of data will be entered into the specified target table and column. A wide variety of datasets (see below) are available to provide a range of realistic looking data.

For example, a column containing customer last names could be "Masked" by implementing a Substitution rule on it using the Names, Surnames, Random dataset. When the Substitution rule is executed as part of the run of the masking set, random last names would be generated and substituted in for each real customer last name. Thus the true last name of the customer would be hidden (preserving privacy and security) but the remaining data would still be referentially relevant and usable as a test system.

A dataset is associated with the target tables column when the rule is created and can be changed at any time simply by editing the rule.

Datasets have options which provide further configuration information. Each dataset offers configuration options specific to its requirements. For example, the Dates, Random dataset offers the ability to set the starting and ending points of the date range.

Note: It is quite possible to add your own custom dataset to the Data Masker system. All that is required is to place a simple text file (with a special naming convention) in the datasets directory. Please see the User Defined datasets help page for more information on how to build your own datasets.

The datasets are installed when the Data Masker software is installed. By default the datasets are stored in a directory named DataSets located below the Data Masker installation directory. The location of this directory can be changed through the use of the configuration options on the Misc. Setup Tab.

The Datasets

Listed below are the datasets currently available with the Data Masker software. More datasets are added all the time - and we are always interested in hearing new ideas. If you have a requirement which cannot be fulfilled by the datasets below please do let us know by emailing us at Support@DataMasker.com.

Bank Account Numbers (NL)
    Dutch Bank Accounts with Checksums.

Bank Account Numbers (NZ)
    New Zealand Bank Accounts with Checksums.

Bank Sort Codes (UK)
    Random UK Bank Sort Codes.

Brazil CPF Numbers
    Brazil CPF Numbers with Checksums.

Brazil CPNJ Numbers
    Brazil CPNJ Numbers with Checksums.

Burgerservicenummer (NL)
    Dutch BSN Numbers with Checksums.

Colours (Random)
    Colours.

Company Names
    Generated Company Names.

Counties (IE)
    Irish County Names.

Counties (UK)
    UK County Names.

Counties (USA)
    USA County Names.

Country Names
    Random Countries.

CPR Numbers (DK)
    Danish CPR Numbers.

Credit Card Expiration Dates
    Credit Card Expiration Dates

Credit Card Numbers, AMEX
    AMEX CC Numbers.

Credit Card Numbers, Diners
    Diners CC Numbers.

Credit Card Numbers, Discover
    Discover CC Numbers.

Credit Card Numbers, MasterCard
    MasterCard CC Numbers.

Credit Card Numbers, VISA
    VISA CC Numbers.

Date Variance
    Date Variance (Random).

Date, User Specified
    User Defined Date.

Dates, Random
    Random Dates.

Dates, Random (as Text)
    Random Dates.

Dates, Sequential
    Sequential Dates.

Dates, Sequential (as Text)
    Sequential Dates.

Departments (FR)
    French Departments.

E-Mail Addresses (Random)
    Random Email Addresses.

HKID Numbers (HK)
    Hong Kong ID Numbers.

Month Names
    Month Names

Names, First+Last, Female
    Female First and Last Names.

Names, First+Last, Male
    Male First and Last Names.

Names, First+Last, Male+Female
    Male and Female First and Last Names.

Names, First Names, Female
    Female First Names.

Names, First Names, Female (DE)
    German Female First Names.

Names, First Names, Female (PT)
    Portugese Female First Names.

Names, First Names, Female (ES)
    Spanish Female First Names.

Names, First Names, Female (FR)
    French Female First Names.

Names, First Names, Female (NL)
    Dutch Female First Names.

Names, First Names, Male
    Male First Names.

Names, First Names, Male (DE)
    German Male First Names.

Names, First Names, Male (PT)
    Portugese Male First Names.

Names, First Names, Male (ES)
    Spanish Male First Names.

Names, First Names, Male (FR)
    French Male First Names.

Names, First Names, Male (NL)
    Dutch Male First Names.

Names, First Names, Male+Female
    Male+Female First Names.

Names, First Names, Male+Female (DE)
    German Male+Female First Names.

Names, First Names, Male+Female (PT)
    Portugese Male+Female First Names.

Names, First Names, Male+Female (ES)
    Spanish Male+Female First Names.

Names, First Names, Male+Female (FR)
    French Male+Female First Names.

Names, First Names, Male+Female (NL)
    Dutch Male+Female First Names.

Names, Surname Suffixes
    Surname Suffixes.

Names, Surname Titles
    Surname Titles.

Names, Surname Titles (Short List)
    Surname Titles. (Short List)

Names, Surnames, Random (DE)
    German Last Names.

Names, Surnames, Random (PT)
    Portugese Last Names.

Names, Surnames, Random (ES)
    Spanish Last Names.

Names, Surnames, Random (FR)
    French Last Names.

Names, Surnames, Random (Large List)
    Last Names (Large List).

Names, Surnames, Random (NL)
    Dutch Last Names.

Names, Surnames, Random (Short List)
    Last Names (Short List).

Nationalities (Random)
    Nationalities.

NI Numbers (UK)
    UK National Insurance Numbers.

NIF Numbers, (ES)
    Numero Identifición Fiscal (Espania).

NIR Numbers, (FR)
    Numéro d'Identification au Répertoire (France).

NRIC Numbers (SG)
    Singapore ID Numbers.

NULL Values
    NULL Values.

Number Variance
    Number Variance (Random).

Numbers, Floating Point (Random)
    Random Floating Point Numbers.

Numbers, Floating Point (Random, as Text)
    Random Floating Point Numbers.

Numbers, Integer (formatted)
    Sequential Integers (formatted).

Numbers, Integer (Random)
    Random Integers.

Numbers, Integer (Random, as Text)
    Random Integers.

Numbers, Integer, Sequential
    Sequential Integers.

Numbers, Integer, Sequential (as Text)
    Sequential Integers (as text).

Numbers, Luhn, Mod(10)
    Numbers with Luhn Mod(10) checksums.

Numbers, Luhn, Mod(10) (as text)
    Numbers with Luhn Mod(10) checksums.

Numbers, User Specified
    User Specified Numbers.

Occupations
    Occupations.

Postcodes, Canadian
    Canadian Postcodes.

Postcodes, FR
    French Postcodes.

Postcodes, NL
    Dutch Postcodes.

Postcodes, UK (Invalid)
    Invalid UK Postcodes.

Provinces, Canadian
    Canadian Provinces.

SIN Numbers (Canadian)
    Social Insurance Numbers (Cdn).

SIN Numbers (Canadian)
    Social Insurance Numbers (Cdn).

SSN Numbers, (USA)
    Social Security Numbers (USA).

State Names (US)
    Random US State Names.

Street Addresses
    Random Street Addresses.

Street Addresses (FR)
    Random French Street Addresses.

Street Addresses (IE)
    Random Irish Street Addresses.

Street Addresses (NL)
    Random Dutch Street Addresses.

SWIFT-BIC Codes
    SWIFT-BIC Codes.

TCP/IP Addresses
    Random TCP/IP Addresses.

Telephone Numbers, (FR)
    Random French Telephone Numbers.

Telephone Numbers, (North America)
    Random North American Telephone Numbers.

Telephone Numbers, (UK)
    Random UK Telephone Numbers.

Text, Alpha-Numeric (Formatted)
    Formatted AlphaNum Text.

Text, Dictionary Words
    Random Words.

Text, Paragraphs of Gibberish
    Paragraphs of Gibberish.

Text, User Specified
    User Supplied Text.

Town/City Names
    Random Town Names.

Town/City Names (FR)
    Random French Town Names.

Town/City Names (IE)
    Random Irish Town Names.

Town/City Names (NL)
    Random Dutch Town Names.

User Defined Dataset
    User Defined Dataset.

Vehicle Registrations (FR)
    French Vehicle Registrations.

Vehicle Registrations (UK)
    UK Vehicle Registrations.

Zip Codes, (US)
    US Zipcodes.


[Net 2000 Ltd. Home][Data Masker Home][Data Masker Manual][Data Masker FAQ]