Define the following connection parameters for a 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 Instance Name
The instance name of the Microsoft SQL Server database.
If the Microsoft SQL Server database is configured to use dynamic port allocation, you can enter the Server Instance Name to identify the listener port. If you enter the instance name, you do not need to enter a Server Port number.
Server Port
TCP/IP listener port for the Microsoft SQL Server database. If you enter the Server Port number, you do not need to enter a Service Instance Name.
Optional Parameters
Additional parameters for the Informatica driver for Microsoft SQL Server.
If the database is SSL enabled, add the following property:
CryptoProtocolVersion=TLSv1,TLSv1.1,TLSv1.2
If you specify multiple protocols, the driver uses the latest version that the server supports. If the driver does not support any of the specified protocols that the server supports, the connection fails and the driver returns an error.
Select custom if you have configured a custom keystore. Select default if you want to use the default keystore preconfigured for use with Dynamic Data Masking.
DBA Username
User name for the database user account to log in to the Microsoft SQL Server database. The database user must be a privileged user that has SELECT access to all the tables that the client user has SELECT access to. This parameter is valid for the default keystore.
DBA Password
Password for the database user. This parameter is valid for the default keystore.
Key Store Name
Name of the custom keystore, defined in the
ddm.security
file. This parameter is valid for custom keystores.
Alias
Alias name for the custom keystore. For CyberArk accounts, the alias name was defined during creation of the CyberArk account. This parameter is valid for custom keystores.
SSL
Select to enable SSL communication between the database and the Dynamic Data Masking Server. For more information on SSL configuration, see the chapter "Security."