๐Ÿ”Œ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 TEST CONNECTION and finally SAVE it.

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