Data Engineering Integration
- Data Engineering Integration 10.5.5
- All Products
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.
|
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 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:
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).
|