Connections

Back Next

Microsoft Azure SQL Data Warehouse V2 connection properties

The following table describes Microsoft Azure SQL Data Warehouse V2 connection properties:

Connection property	Description
Runtime Environment	The name of the runtime environment where you want to run the tasks.
Azure DW JDBC URL	Microsoft Azure Data Warehouse 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 SQL Data Warehouse account. Provide AAD user name for AAD authentication.
Azure DW JDBC Password	Password to connect to the Microsoft Azure SQL Data Warehouse account.
Azure DW Schema Name	Name of the schema in Microsoft Azure SQL Data Warehouse.
Azure Blob Account Name	Name of the Microsoft Azure Storage account to stage the files.
Azure Blob Account Key	Microsoft Azure Storage access key to stage the files.