| Field | Description |
|---|---|
| Name | Specifies the name of data connection. This is a mandatory field. Example: SQLServerDataConnection |
| Description | Allows you to describe the purpose of this data connection. Example: Connection to the SQL Server database for financial reporting. |
| Agent to access data | Select the agent from the dropdown that connects to the database. It helps securely access data from your network. |
| Host name | Specifies the host name that can be Cloud Azure or on-premise server. This is a mandatory field. Example: sqlserver.company.com |
| Port number | Mention the port number to access the database server. The default value is 1433. This is a mandatory field. Example: 1433 |
| Database | Specifies the name of database to connect to on the designated host server. This is a mandatory field. Example: finance_db |
| Additional URL parameters | Specify the additional JDBC driver connection parameters in the key=value pairs format separated by semicolon. Example: key1=value1;key2=value2. Allowed parameters can be referred here. Example: encrypt=true;trustServerCertificate=false |
| You will see the advanced options if your worksapce is enabled with Advanced connectivity bundle. | |
|
Advanced Options |
Allows you to configure the connector log level and specify additional connection parameters. The default value for Spatial is set to false, which disables the cataloging of spatial data. To use spatial data, set it to true. |