Transparent Archive Guide

Back Next

Defining the Microsoft SQL Server Database

Define the Microsoft SQL Server production database in the Management Console.

In the Management Console, click

Tree

Add Database

The

Add Database

window appears.

Select the SQL Server database type.

Define the following properties for the Microsoft SQL Server database:

DDM Database Name: Name for the database in the Management Console tree.
Server Address: Server host name or TCP/IP address for the Microsoft SQL Server database.
Verify that there is no firewall that prohibits the Dynamic Data Masking Server from connecting to the database server and port number.
Server Port: TCP/IP listener port for the Microsoft SQL Server database that the database link uses.
Optional Parameters: Additional parameters for the Informatica driver for Microsoft SQL Server.
Database Name: Optional name of a Microsoft SQL Server database. Used for manual upgrade of Dynamic Data Masking for Microsoft SQL Server service.
Rule Set: Optional rule set you can define for a specific database in addition to the Default Rule Set. Used for manual upgrade of Dynamic Data Masking for Microsoft SQL Server service.
DDM Port: Dynamic Data Masking listener port. Use DDM Port for a manual upgrade of the Dynamic Data Masking for Microsoft SQL Server service.
Default Rule Set: Rule set that applies to all incoming SQL statement requests. Used for manual upgrade of Dynamic Data Masking for Microsoft SQL Server service.
DBA Username: User name for the database user account to log in to the Microsoft SQL Server database.
DBA Password: Password for the database user.