Synapse connection reference

You need specific information to establish a seamless and secure connection. The following fields are required.

Connection name

Enter a new {connection} connection name.

Connection description

Provide a short description of the connection. (Optional)

Host

Enter the host name associated with the {connection} database.

Port

Enter the port number associated with the {connection} database.

If you are using SQL Server, enter 1433.
(Service Account only) User

Enter the {connection} account username.

If you are using SQL Server, enter the login for your SQL Server database.
(Service Account only) Password

Enter the {connection} account password.

Database

Specify the database associated with the account.

(OAuth only) OAuth Client ID

Specify the OAuth client ID associated with the account.

(OAuth only) OAuth Client Secret

Specify the OAuth client secret associated with the account.

(OAuth only) Scope

Enter this for your Synapse OAuth connection:

offline_access openid https://sql.azuresynapse.net/.default

Scope value is the same for all Synapse OAuth connections.

(OAuth only) Auth Url

Specify the auth URL associated with the account.

(OAuth only) Access token Url

Specify the access token URL associated with the account.