Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Microsoft Azure SQL Data Warehouse Connection Properties

Microsoft Azure SQL Data Warehouse Connection Properties

Use a Microsoft Azure SQL Data Warehouse connection to access a Microsoft Azure SQL Data Warehouse.
The order of the connection properties might vary depending on the tool where you view them.
You can create and manage a Microsoft Azure SQL Data Warehouse connection in the Administrator tool or the Developer tool. The following table describes the Microsoft Azure SQL Data Warehouse connection properties:
Property
Description
Name
The name of the connection. The name is not case sensitive and must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
ID
String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
Description
The description of the connection. The description cannot exceed 4,000 characters.
Location
The domain where you want to create the connection.
Type
The connection type. Select Azure SQL Data Warehouse.
The following table describes the properties for metadata access:
Property
Description
Azure DW JDBC URL
Microsoft Azure Data Warehouse JDBC connection string. For example, you can enter the following connection string:
jdbc:sqlserver:// <Server>.database.windows.net:1433;database=<Database>
The Administrator can download the URL from Microsoft Azure portal.
Azure DW JDBC Username
User name to connect to the Microsoft Azure SQL Data Warehouse account. You must have permission to read, write, and truncate data in Microsoft Azure SQL Data Warehouse.
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 Storage Type
Type of Azure storage to stage the files. You can select any of the following storage type:
  • Azure Blob. Default. To use Microsoft Azure Blob Storage to stage the files.
  • ADLS Gen2. To use Microsoft Azure Data Lake Storage Gen2 as storage to stage the files.
Azure Blob Account Name
Name of the Microsoft Azure Storage account to stage the files.
Azure Blob Account Key
The key that authenticates the access to the Blob storage account.
ADLS Gen2 Storage Account Name
Name of the Microsoft Azure Data Lake Storage Gen2 account to stage the files.
ADLS Gen2 Account Key
Microsoft Azure Data Lake Storage Gen2 access key to stage the files.
Blob End-point
Type of Microsoft Azure endpoints.
Select one of the following options:
  • core.windows.net
    : Default
  • core.usgovcloudapi.net
    : Select to access the US government Microsoft Azure Data Warehouse endpoints.
  • core.chinacloudapi.cn
    : Select to access a Microsoft Azure Data Warehouse endpoint in the China region.
You can configure the US government Microsoft Azure end-points when a mapping runs in the native environment and on the Spark engine.
VNet Rule
Enable to connect to a Microsoft Azure SQL Data Warehouse endpoint residing in a virtual network (VNet).

0 COMMENTS

We’d like to hear from you!