🔌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

Azure MSSQL connection form

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.

Create a dataset from a AzureMSSQL datasource

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".