🔌Setting up a Microsoft SQL Server connector

Configuring the Microsoft Server SQL connector (MSSQL ) connector in Toucan

Fill in the connection information after opening the modal of the connector:

Basic Connection Options

Name (mandatory)

• Format: string

• Description: a name to identify your connection

• Example: "my_MSSQL"

Host (mandatory)

• Format: String

• Description: The domain name or IP address of your database server

• Example: "db.example.com" or "192.168.1.100"

Port (optional)

• Format: Integer

• Description: The listening port of your database server

• Example: 1433

User (mandatory)

• Format: String

• Description: Your login username

• Example: "myuser"

Password (mandatory)

• Format: String

• Description: Your login password

• Example: "secretpassword123"

Connect Timeout (optional)

• Format: Integer

• Description: Connection timeout in seconds

• Example: 30

After Configuration

Then click on SAVE to save the connection After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasources" tab

Fetch data from MSSQL and create a dataset

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