Data Accelerator for Azure > Target and source connections > Target connections
  

Target connections

Create one target connection for each Microsoft Azure data warehouse that you want to load data to. Create target connections on the Configure the target page. To create a target connection, select the connection type, enter the connection properties, and then click Save.
You can load data to Microsoft Azure data warehouse using the following connection types:
Microsoft Azure Data Warehouse
Use a Microsoft Azure Data Warehouse connection to write data to a Microsoft Azure SQL Data Warehouse target.
When you write data to a Microsoft Azure SQL Data Warehouse target, the connector stages data files to Microsoft Azure Storage and uses T-SQL commands with Microsoft Polybase to extract or load relational and non-relational data in parallel.
Note: This option is provided for backward compatibility with previous versions of Data Accelerator for Azure. For new Azure data sync tasks, use a Microsoft Azure Data Warehouse V3 connection.
Microsoft Azure Data Warehouse V3
Use a Microsoft Azure Data Warehouse V3 connection to write data to a Microsoft Azure SQL Data Warehouse target. The target database can be a case-sensitive database. You can also write data to a Microsoft Azure SQL Data Warehouse endpoint that resides in a virtual network (VNet).
When you write data to a Microsoft Azure SQL Data Warehouse target, the connector stages data files to Microsoft Azure Storage and uses T-SQL commands with Microsoft Polybase to extract or load relational and non-relational data in parallel. You can use Microsoft SQL Server or Azure Active Directory authentication to connect to a Microsoft Azure SQL Data Warehouse target.

Microsoft Azure Data Warehouse connection properties

To load data to a Microsoft Azure data warehouse using a Microsoft Azure Data Warehouse connection, select Azure DW as the connection type on the Configure the target page.
The following table describes the target connection properties:
Property
Description
Name
Name of the connection that you are creating to Microsoft Azure.
Description
Optional description for the connection.
Type
Connection type. Select Azure DW.
Runtime environment
Name of the Secure Agent group that will be used to access the Microsoft Azure data warehouse.
Azure DW JDBC URL
Microsoft Azure Data Warehouse JDBC connection string. For example:
jdbc:sqlserver://<server>.database.windows.net:1433;database=<database>
Azure DW JDBC username
User name to connect to the Microsoft Azure SQL Data Warehouse account.
Azure DW JDBC password
Password to connect to the Microsoft Azure SQL Data Warehouse account.
Azure DW schema name
Name of the schema in the Microsoft Azure SQL Data Warehouse.
Azure blob account name
Name of the Microsoft Azure Blob Storage account to stage the files.
Azure blob account key
Microsoft Azure Blob Storage access key to stage the files.

Microsoft Azure Data Warehouse V3 connection properties

To load data to a Microsoft Azure data warehouse using a Microsoft Azure Data Warehouse V3 connection, select Microsoft Azure SQL Data Warehouse V3 as the connection type on the Configure the target page.
The following table describes the target connection properties:
Property
Description
Name
Name of the connection that you are creating to Microsoft Azure.
Description
Optional description for the connection.
Type
Connection type. Select Microsoft Azure SQL Data Warehouse V3.
Runtime environment
Name of the Secure Agent group that will be used to access the Microsoft Azure data warehouse.
Azure DW JDBC URL
Microsoft Azure Data Warehouse JDBC connection string.
For example, for Microsoft SQL Server authentication:
jdbc:sqlserver://<server>.database.windows.net:1433;database=<database>
For 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 the 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 the Microsoft Azure SQL Data Warehouse.
Azure blob account name
Name of the Microsoft Azure Blob Storage account to stage the files.
Azure blob account key
Microsoft Azure Blob Storage access key to stage the files.
Blob end-point
Type of Microsoft Azure endpoint. Select one of the following endpoint types:
  • - core.windows.net. This is the default option.
  • - core.usgovcloudapi.net. US government Microsoft Azure endpoints.
  • - core.chinacloudapi.cn. Not applicable.
VNet rule
Enable to connect to a Microsoft Azure SQL Data Warehouse endpoint residing in a virtual network (VNet).