🔌Setting up an Azure SQL connector
This connector is used to connect to an Azure SQL database.
Configuring the Azure SQL connector in Toucan
Fill in the mandatory connection information:
Host
User
Password
Then click on SAVE
After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab
Selecting data from Azure SQL
To create a dataset from AzureSQL, click on the "create from icon", you will then be able to:
Select the Database
Add a Query: you can query tables, views, and even stored procedures using the AZURE SQL.
After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".
Last updated