Following are the options specific to SASSPD:
Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.
Hostname: Enter the Hostname of the SASSPD database or select from the list of available IPs. You can also search for the hostnames and IP addresses of databases by Find DBMS.
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.
Port Number: Enter the Port Number for establishing a connection. You can also edit the port number later, if required.
SNET Port Number: Enter the SNET Port Number.
SNET Hostname: Enter the SNET Hostname.
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 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.
Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box. Check the Include System Schema/DB Name checkbox to include the required schemas and databases and click Fetch Metadata. It will list down the available databases/schemas for the connection.
Check the databases/schemas name that you want to add as the target databases/schemas. The checked databases or schemas will appear in the Target Databases/Schemas panel.
*Note:For multiple Instances in SQL Server, select the required instance and click Edit to view and select the databases and schemas.
For SAS and SAS SPD servers there is no Fetch Metadata functionality, user must select the directories for SAS and for SAS SPD, select the directories available on the SNET server at the time of task execution.
To proceed further for remaining steps, refer Step 2 in RDBMS Detection Connection.