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 Azure SQL Data Warehouse Server or select from the list of available IPs.
Group/IP Range: Select the Group/IP range from the drop-down. For details on how to create and assign an IP range, please refer to the PK Protect Installation Guide.
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: It 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 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.
Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box and press enter. This lists down the existing databases for the selected connection. Check the Include System Schema/DB Name checkbox if you want to include the system schema in the panel. It will list down the available databases/schemas for the connection.
Check the checkbox next to the name of the databases/schemas that you want to add as the target databases/schemas. The checked databases or schemas will be appeared in the Target Databases/Schemas panel.