Data Masker for SQL Server 6

About 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.

Colors (Random)
Colors.

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.


Didn't find what you were looking for?