Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Microsoft Azure SQL Database Connection Properties

Microsoft Azure SQL Database Connection Properties

Define the following connection parameters for a Microsoft Azure SQL Database:
DDM Database Name
Name for the database in the Management Console tree.
Server Address
Server host name or TCP/IP address for the 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 database.
Optional Parameters
Additional parameters for the Informatica driver for the database.
If you add the AD user as the DDM administrator, set the following property:
authenticationMethod=ActiveDirectoryPassword
Keystore
Select
Custom
if you have configured a custom keystore. Select
Default
if you want to use the default keystore that is preconfigured for use with Dynamic Data Masking.
DBA Username
User name for the database user account to log in to Microsoft Azure SQL Database. The database user must have SELECT access privileges for all the tables to which the client user has SELECT access privileges. This parameter is valid for the default keystore.
DBA Password
Password for the database user. This parameter is valid for the default keystore.
KeyStore 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 when the CyberArk account was created. 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 Security.

0 COMMENTS

We’d like to hear from you!