Name of the connection.

Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,

Maximum length is 255 characters.

Description of the connection. Maximum length is 4000 characters.

The name of the runtime environment where you want to run tasks.

Select a Secure Agent, Hosted Agent, or serverless runtime environment.

Hosted Agent doesn't apply to mappings in advanced mode.

The Microsoft Azure Synapse SQL JDBC connection string.

Use the following string to connect to Microsoft Azure Synapse SQL:

jdbc:sqlserver://<Server>.database.windows.net:1433; database=<Database>

You can include an authentication parameter in the connection string to specify the authentication type. You can configure the following authentication types to connect to Microsoft Azure Synapse SQL:

Microsoft SQL Server
Azure Active Directory
Managed Identity
Service Principal

If you don't include an authentication parameter in the connection string, the Secure Agent uses Microsoft SQL Server authentication as the authentication type.

Use the following string to connect to a serverless SQL pool in Microsoft Azure Synapse SQL:

jdbc:sqlserver://<Serverless SQL endpoint>:1433; database=<Database>;Authentication=ActiveDirectoryMsi;

Connection string format for Microsoft SQL Server authentication

jdbc:sqlserver://<Server>.database.windows.net:1433; database=<Database>

Connection string format for Azure Active Directory (AAD) authentication

jdbc:sqlserver://<Server>.database.windows.net:1433; database=<Database>;encrypt=true;trustServerCertificate=false; hostNameInCertificate=*.database.windows.net;loginTimeout=30; Authentication=ActiveDirectoryPassword;

Connection string format for Service Principal authentication

jdbc:sqlserver://<Server>.database.windows.net:1433; database=<Database>;encrypt=true;trustServerCertificate=false; hostNameInCertificate=*.database.windows.net;loginTimeout=30; Authentication= ActiveDirectoryServicePrincipal;

Connection string format for Managed Identity authentication

jdbc:sqlserver://<Server>.database.windows.net:1433; database=<Database>;Authentication=ActiveDirectoryMsi;

This property doesn't apply to Managed Identity authentication.

This property doesn't apply to Managed Identity authentication.

The client ID of the user-assigned managed identity.

If you use system-assigned managed identity, leave the field empty.

Name of the schema in Microsoft Azure Synapse SQL.