🔌Add an Azure SQL connector
How to connect to an Azure SQL database.
Connector features
You can use the Toucan Azure SQL connector to connect to your Azure SQL cluster with a basic authentication and access tables with a SQL query.
With this connection, you can fetch data from your Azure SQL to fill your charts and dashboards.
Configuring an Azure SQL connection
Follow the steps described in Add a connector, choose AzureSQL and fill out the form with the following info:
Name (mandatory)
String
Use it to identify your connection
MyMsSQLConnection
Host (mandatory)
String
The domain name or IP address of your database server
"db.example.com" or "192.168.1.100"
Port (optional)
Integer
The listening port of your database server
1433
User (mandatory)
String
Your login username
my_user
Password (mandatory)
String
Your login password
my_password
Connect Timeout (optional)
Integer
Connection timeout in seconds
30
Trust server certificate (optional)
Boolean
Disable server certificate validation, can be used if the certificate used is untrusted. Connexion stays encrypted
Retry Policy (optionl)
Boolean
Boolean allows to configure a retry policy if the connection is flaky.
max attempts: maximum number of retries before giving up
max_delay: in seconds, above the connection is dropped
wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)
Integer
Slow queries' cache expiration time in seconds
Click on the TEST CONNECTION button then SAVE the connection
After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab
Create a dataset from an Azure SQL connection
To create a dataset from AzureSQL, click on the "create from icon", you will then be able to:
Select the
DatabaseAdd 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
Was this helpful?