- All Products
A name for the connection. This name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Spaces at the beginning or end of the name are trimmed and are not saved as part of the name. Maximum length is 100 characters. Connection names are not case sensitive.
An optional description for the connection. Maximum length is 255 characters.
The type of connection. Ensure that the type is for Microsoft Azure Synapse Analytics - Database Ingestion.
The name of the runtime environment where you want to run the
application ingestiontasks or
database ingestiontasks. You define runtime environments in
You cannot run application ingestion tasks and database ingestion tasks on a Hosted Agent or serverless runtime environment.
Azure Synapse Analytics JDBC URL
The Microsoft Azure Synapse Analytics (formerly SQL Data Warehouse) JDBC connection string.
Example connection string for Microsoft SQL Server authentication:
Example connection string for Azure Active Directory (AAD) authentication:
The default authentication type is Microsoft SQL Server authentication.
Azure Synapse Analytics JDBC Username
The user name to use for connecting to the Microsoft Azure Synapse Analytics account. Provide the AAD user name for AAD authentication.
Azure Synapse Analytics JDBC Password
The password to use for connecting to the Microsoft Azure Synapse Analytics account.
Azure Synapse Analytics Schema Name
The name of the schema in the Microsoft Azure Synapse Analytics target.
ADLS Gen2 Account Name
The name of the Microsoft Azure Data Lake Storage Gen2 account.
The ID of your client application for completing the OAuth Authentication in the Active Directory.
The client secret key for completing the OAuth Authentication in the Active Directory.
The Microsoft Azure Data Lake Storage Gen2 directory that
Mass Ingestion Applicationsand Mass Ingestion Databases uses to stage data in files. The default is the root directory.
The name of an existing file system in the Microsoft Azure Data Lake Storage Gen2 account.
The Directory ID of the Azure Active Directory.