🔌Add an Azure SQL connector

This connector is used to connect to an Azure SQL database.

Configuring an Azure SQL connection

Fill in the mandatory connection information:

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?