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

The Data Masker for SQL Server Manual
Table of Contents

The Data Masker software helps secure sensitive data in test, training and development databases by replacing it with realistic looking false information. The data sanitization process ensures the security and privacy of the information while still preserving the look-and-feel of the original.

This manual refers to the Data Masker product for SQL Server databases. There is also a version available for Oracle databases.

If you wish to learn how to use the Data Masker for SQL Server software the best method is to read the Quick Start Guide. It will give you an introduction of the concepts and help you to learn about the Data Masker software.

The Data Masker software contains collections of masking rules (called masking sets) designed to scramble information in the well known Pubs and Northwind sample databases. The Quick Start Guide suggests additional rules to add to these masking sets which can enhance your understanding of the product.

Key Features
The Data Masker Key Features Document

Online Tutorials
Installing Data Masker SQL Server Components [local] [internet]
Configuring SQL Server Logins for Data Masker [local] [internet]
Loading and Running Masking Sets [local] [internet]
Creating a Rule Controller [local] [internet]
Creating Substitution Rules [local] [internet]
Creating Command Rules [local] [internet]
Creating Insertion Rules [local] [internet]
Creating Row-Internal Synchronization Rules [local]) [internet]
Creating Table-Internal Synchronization Rules [local] [internet]
Creating Table-To-Table Synchronization Rules [local] [internet]

Summary pages
Other Useful Software from Net 2000 Ltd.
The Data Masker Home Page
Why use the Data Masker Software?
The Data Masker FAQ

White Papers
Data Scrambling Issues <-- Read This, It is Very Useful
Data Sanitization Techniques

General Topics
The Data Masker Manual Home Page (this page)
The Quick Start Guide
The Client Software Main Help Page
The Data Masker SQL Server Configuration Tool
About Masking Rules
About Data Sets
About User Defined Data Sets
About WHERE Clauses and Sampling

Masking Rules
About Rule Controllers
About Command Rules
About Insertion Rules
About Substitution Rules
About Row-Internal Synchronization Rules
About Table-Internal Synchronization
About Table-To-Table Synchronization

Major Data Masker Application Components
The Build Rules Tab
The Misc. Setup Tab
The Rule Statistics Tab
The New Rule Controller Form
The New Command Rule Form
The New Insertion Rule Form
The New Substitution Rule Form
The New Row-Internal Synchronization Rule Form
The New Table-Internal Synchronization Rule Form
The New Table-To-Table Synchronization Rule Form
The About Data Masker Form
The Masking Set Notes Form

Sample Masking Sets and Databases
Suggested Rules for the DMTest Sample Database
Suggested Rules for the Northwind Sample Database
Suggested Rules for the Pubs Sample Database
An ER Diagram for the DMTest Sample Database
An ER Diagram for the Northwind Sample Database
An ER Diagram for the Pubs Sample Database


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