This section provides you the details on various fields required to configure Azure Synapse analytics server in Data Integrity Suite.
| Field | Description |
|---|---|
| Name | Specifies the name of data connection. This is a mandatory field. Example:AzureSynapseDataConnection |
| Description | Allows you to describe the purpose of this data connection. Example: Connection to the AzureSynapse 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.comkk |
| Port number | Mention the port number to access the database server. The default value is 3306. This is a mandatory field. Example: 3306 |
| Database | Specifies the name of database to connect to on the designated host server. This is a mandatory field. Example: finance_db |
|
Advanced Options |
For advanced configuration, refer Advanced connectivity bundle |