Connections > Connection properties > Microsoft Azure Synapse SQL connection properties
  

Microsoft Azure Synapse SQL connection properties

The following table describes Microsoft Azure Synapse SQL connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks. Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
Azure DW JDBC URL
Microsoft Azure Synapse SQL JDBC connection string.
Example for Microsoft SQL Server authentication:
jdbc:sqlserver://<Server>.database.windows.net:1433;database=<Database>
Example 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;
The default authentication is Microsoft SQL Server authentication.
Azure DW JDBC Username
User name to connect to the Microsoft Azure Synapse SQL account. Provide AAD user name for AAD authentication.
Azure DW JDBC Password
Password to connect to the Microsoft Azure Synapse SQL account.
Azure DW Schema Name
Name of the schema in Microsoft Azure Synapse SQL.
Azure Storage Type
Type of Azure storage to stage the files. You can select any of the following storage type:
  • - Azure Blob. Default. To use Microsoft Azure Blob Storage to stage the files.
  • - ADLS Gen2. To use Microsoft Azure Data Lake Storage Gen2 as storage to stage the files.
Authentication Type
Authentication type to connect to Azure storage to stage the files.
Select one of the following options:
  • - Shared Key Authentication. Select to use the account name and account key to connect to Microsoft Azure Blob Storage or Microsoft Azure Data Lake Storage Gen2.
  • - Service Principal Authentication. Applicable to Microsoft Azure Data Lake Storage Gen2. To use Service Principal authentication, you must register an application in the Azure Active Directory, generate a client secret, and then assign the Storage Blob Contributor role to the application.
Azure Blob Account Name
Applicable to Shared Key Authentication for Microsoft Azure Blob Storage.
Name of the Microsoft Azure Blob Storage account to stage the files.
Azure Blob Account Key
Applicable to Shared Key Authentication for Microsoft Azure Blob Storage.
Microsoft Azure Blob Storage access key to stage the files.
ADLS Gen2 Storage Account Name
Applicable to Shared Key Authentication and Service Principal Authentication for Microsoft Azure Data Lake Storage Gen2.
Name of the Microsoft Azure Data Lake Storage Gen2 account to stage the files.
ADLS Gen2 Account Key
Applicable to Shared Key Authentication for Microsoft Azure Data Lake Storage Gen2.
Microsoft Azure Data Lake Storage Gen2 access key to stage the files.
Client ID
Applicable to Service Principal Authentication for Microsoft Azure Data Lake Storage Gen2.
The application ID or client ID for your application registered in the Azure Active Directory.
Client Secret
Applicable to Service Principal Authentication for Microsoft Azure Data Lake Storage Gen2.
The client secret for your application.
Tenant ID
Applicable to Service Principal Authentication for Microsoft Azure Data Lake Storage Gen2.
The directory ID or tenant ID for your application.
Blob End-point
Type of Microsoft Azure endpoints. You can select any of the following endpoints:
  • - core.windows.net. Default.
  • - core.usgovcloudapi.net. To select the Azure Government endpoints.
VNet Rule
Enable to connect to a Microsoft Azure Synapse SQL endpoint residing in a virtual network (VNet).
When you use a serverless runtime environment, you cannot connect to a Microsoft Azure Synapse SQL endpoint residing in a virtual network.