🔌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:
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
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
Was this helpful?