MS SQL Server
Create your MS SQL Server connection.
Last updated
Create your MS SQL Server connection.
Last updated
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.
To connect to your MS SQL Server database, you'll need to enter the parameters in the Team connections modal:
You can name your connection however you'd like. This is the display name for your connection across Quadratic and your team.
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:
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.
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:
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:
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:
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.
