Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

PowerExchange for Microsoft Azure SQL Data Warehouse V3 Connections

PowerExchange for Microsoft Azure SQL Data Warehouse V3 Connections

A Microsoft Azure SQL Data Warehouse connection extracts data from and loads data to the Microsoft Azure SQL Data Warehouse. PowerExchange for Microsoft Azure SQL Data Warehouse V3 uses SOAP to connect to Microsoft Azure SQL Data Warehouse.
The following table describes PowerExchange for Microsoft Azure SQL Data Warehouse V3 connection properties:
Connection Properties
Description
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 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 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.
Blob End-point
Type of Microsoft Azure end-points. You can select any of the following end-points:
  • core.windows.net
    : Default
  • core.usgovcloudapi.net
    : To select the US government Microsoft Azure end-points
  • core.chinacloudapi.cn
    : Not applicable