Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Global Parameters
  10. Dictionaries
  11. User-Defined Datatypes

AzureDWv3 Connections

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.