Following are the options specific to SQL Server:
Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.
SSL: For an additional layer of security, check the SSL (Secure Socket Layer) checkbox.
Server Name: Enter the name of the SQL Server or select from the list of available IPs. You can also search for the hostnames and IP addresses of databases by Find DBMS/Tasks.
IP Address: Enter the IP Address for the connection.
Authentication Method: The following authentication methods are available for SQL Server:
SQL Server: Authenticates the connection using SQL Server Username and Password.
Windows Impersonation: Authenticates the connection using the Windows Impersonation Username and Password.
Windows: Authenticates the connection based on the connection to the local IP address.
Port Number: Enter the Port Number for establishing a connection. You can also edit the port number later, if required.
Database Name: Enter the name of the database.
Username: Enter the database username.
Password: Enter the database password.
Use Connection String: A Connection String specifies the information about the data source and the means of connecting to it. Check the Use Connection String checkbox and provide the connection string. Use this option if you want to authenticate the connection using a connection string instead of through username and password.
Connection Attribute: Select the attribute name from the Connection Attribute drop-down. This functionality allows you to add tags to the created connection.
Target Databases Details: It allows you to add a database as the target database to store the masked data. To add a database as Target Database, enter name of the database in the Target Database textbox. Click the Add button. The database will be added in the Target Database panel. Click pen icon to edit the name of the database. Click trash icon to delete the database.
*Note: More than one database can be added as the target database.
To proceed further for remaining steps, refer Step 3 in RDBMS Masking Connection.