Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge.

Visit the official Paxata Documentation portal for all of your doc needs.

How to configure an Azure SQL Data Warehouse connector

MelanieMelanie Posts: 51 admin
edited October 23, 2018 12:02AM in Paxata Fundamentals

To configure an Azure SQL Warehouse connector in Paxata, you must enter the following parameters before you can save the data source configuration form: 

General: the name you want to assign to the connector.
Database URL: the URL of the database to import from or export to
External Data Source Name: the name of the external data source in SQL Data Warehouse for accessing data in Azure Data Lake.
ADL URI: URI of the Azure Data Lake. Values start with adl://
Data Lake Upload Directory: directory within ADLS into which Paxata will upload data for SQL Data Warehouse external tables.
Application ID: the application ID from your Azure Active Directory application
OAUTH 2.0 Token Endpoint: OAUTH 2.0 token endpoint from your Azure Active directory application

Additionally, you should go ahead and complete the following fields. Otherwise, you'll be required to complete them every time you want to connect to the data source:
User: the storage access key used to authenticate with your Azure Blob storage account.

Password: the subdomain name of your unique Azure URL address.
Application Access Key Value: base64-encoded value of access key associated with your Azure Active Directory Application.

Here's a screenshot of the Azure SQL Warehouse connector form.


Sign In or Register to comment.