Connections > Microsoft Azure SQL Data Warehouse V2 connection properties
  

Microsoft Azure SQL Data Warehouse V2 connection properties

The following table describes Microsoft Azure SQL Data Warehouse V2 connection properties:
Important: Microsoft Azure SQL Data Warehouse V2 Connector is deprecated and has been moved to maintenance mode. Informatica intends to drop support in a future release. Informatica recommends that you use Microsoft Azure Synapse SQL Connector to access Microsoft Azure SQL Data Warehouse.
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.