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 and replication tasks and database ingestion and replication tasks, which you configure in the Data Ingestion and Replication service.
Note: Some properties are for Microsoft Azure Data Lake Storage Gen2. Application Ingestion and Replication and Database Ingestion and Replication 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 Microsoft Azure Synapse Analytics Database Ingestion.
Runtime Environment
The name of the runtime environment where you want to run the application ingestion and replication tasks or database ingestion and replication tasks. You define runtime environments in Administrator.
Note: You cannot run application ingestion and replication tasks or database ingestion and replication 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 Application Ingestion and Replication and Database Ingestion and Replication use 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.