MS SQL Server
Create your MS SQL Server connection.
You can create your MS SQL Server connection from either your team's dashboard or directly from a spreadsheet. From the dashboard, navigate to the Connections page or from a spreadsheet press / and then Manage connections.
Connection details
To connect to your MS SQL Server database, you'll need to enter the parameters in the Team connections modal:
Connection name
You can name your connection however you'd like. This is the display name for your connection across Quadratic and your team.
Host name
This is the connection host, the direct connection to your database. It can be an IP address or URL. You might see a connection string that looks something like this:
The hostname is the IP address or URL. From the above connection string, this would be the host, which you would add to the Hostname field:
Port number
This is the connection port; you might see it at the end of your hostname after the colon. It is typically a four-digit number. From the above example, add this number to the Port field. 3306
is the default port number for MySQL.
Database name
This is the name of the database you want to connect to. Your database can have multiple tables - be sure to use the database name and not the name of a table. Example database name:
Username
This is an authentication detail that depends on your database account username. Some common defaults include admin
or default
. This information is in your database's authentication details, found in your database's authentication settings, or received from your database administrator. Example:
Password
This is the password you use to connect to your database. This information is in your database's authentication details, found in your database's authentication settings, or received from your database administrator. Example:
IP allow-list
Databases behind a firewall may require you to whitelist Quadratic IP addresses, which are: 44.240.255.40 54.68.134.35
* These IP addresses do not apply to self-hosted instances
If you need help setting up your data sources, contact us. Some extra resources and instructions vary depending on where your database lives.
Once you've made your connection, you can use it directly in spreadsheets to read data to your spreadsheets. Learn how here.
Last updated