Connections > Microsoft Azure Synapse Analytics Database Ingestion connection properties
  

Microsoft Azure Synapse Analytics Database Ingestion connection properties

When you define a Microsoft Azure Synapse Analytics Database Ingestion connection, you must configure connection properties. You can use this connection type in application ingestion tasks and database ingestion tasks, which you configure in the Mass Ingestion service.
Note: Some properties are for Microsoft Azure Data Lake Storage Gen2. Mass Ingestion Applications and Mass Ingestion Databases use Microsoft Azure Data Lake Storage Gen2 to stage data in files before sending the data to the Microsoft Azure Synapse Analytics target tables.
The following table describes the connection properties:
Property
Description
Connection Name
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.
Description
An optional description for the connection. Maximum length is 255 characters.
Type
The type of connection. Ensure that the type is for Microsoft Azure Synapse Analytics - Database Ingestion.
Runtime Environment
The name of the runtime environment where you want to run the application ingestion tasks or database ingestion tasks. You define runtime environments in Administrator.
Note: 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:
jdbc:sqlserver://server.database.windows.net:1433;database=database
Example connection string 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;
Note: 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.
Client Id
The ID of your client application for completing the OAuth Authentication in the Active Directory.
Client Secret
The client secret key for completing the OAuth Authentication in the Active Directory.
Directory
The Microsoft Azure Data Lake Storage Gen2 directory that Mass Ingestion Applications and Mass Ingestion Databases uses to stage data in files. The default is the root directory.
Filesystem Name
The name of an existing file system in the Microsoft Azure Data Lake Storage Gen2 account.
Tenant ID
The Directory ID of the Azure Active Directory.