Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge.
How to configure an Azure SQL Data Warehouse connector
To configure an Azure SQL Warehouse connector in Paxata, you must enter the following parameters before you can save the data source configuration form:
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
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
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.