🔌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.

Changelog

April 25 - This connector supports the option Trust server certificate

Configuring an Azure SQL connection

Follow the steps described in Add a connector, choose AzureSQL and fill out the form with the following info:

Field
Format / Type
Description
Example

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

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 Database

  • Add a Query: you can query tables, views, and even stored procedures using the AZURE SQL.

Last updated

Was this helpful?