🔌Add a Microsoft SQL (MSSQL) Server connector

Connector features

You can use the Toucan Microsoft SQL Server (MSSQL) connector to connect to your MSSQL account with a basic authentication and access tables with a SQL query.

With this connection, you can fetch data from your MSSQL to fill your charts and dashboards.

Changelog

April 25 - This connector supports the option Trust server certificate

Configuring a Microsoft Server SQL connector (MSSQL ) connection

Follow the steps described in Add a connector, choose MSSQL 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 (optional)	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 a MSSQL connection

To create a dataset from MSSQL, click on the "create a new dataset from this connector", you will then be able to:

• Select the Database

• Select the Table

• and write your SQL query in Query

The fields: Validation rules, Parameters,Slow queries cache expiration time are optional

After selecting data from your connector you will be able to create a dataset thanks to YouPrep

For more info, see the dedicated section Creating datasets

Additional notes

• We use for the the MSSQL connector uses the ODBC Driver 18 for SQL Server

• SQL Server will use the default database for the user