Administrator Guide

10.5.3
- 10.5.6
- 10.5.5
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

AzureDWv3 Connections

You can create an AzureDWv3 connection in Test Data Manager to perform data masking operations. Use this connection type to create connections to Microsoft Azure SQL Data Warehouse databases for data masking tasks. To use a Microsoft Azure SQL Data Warehouse database for data subset, data generation, and test data warehouse tasks, use the Microsoft SQL Server connection type.

The following table describes the database connection properties for a DB2 for Linux, UNIX and Windows database:

Property	Description
Name	Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] \| \ : ; " ' < , > . ? /
Connection Type	Required. The connection type. Select AzureDWv3.
Description	The description of the connection. The description cannot exceed 255 characters.
Owner	The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.
Azure DW JDBC URL	Microsoft Azure SQL Data Warehouse JDBC connection string. For example, you can enter the following connection string: jdbc:sqlserver://<Server>.database.windows.net:1433;database=<Database>
Azure DW JDBC User name	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 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.

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

AzureDWv3 Connections

AzureDWv3 Connections