Microsoft SQL
You can connect to your MSSQL database to explore data, combine them with other data sources and build apps on top of them as a data foundation.
Connecting to your MySQL Database
To connect your MSSQL database, follow the steps below:
Go to Data Management and click on "New source" to create a new data source.
Select MSSQL from the list of available data sources.
Name your data source connection and provide the connection details:
| Setting | Description |
|---|---|
Hosts | The host url of the server the database runs on. |
Port | The port number through which the requests should run through. By default we set the port to 1433 since that's the usual port used for MSSQL database requests. |
Database name | The name of the database on the host that you wish to connect to. |
Username & Password | These are the credentials of the user account that has the required access permissions for the database. |
Connect using SSL | You can specify if you want to connect to the server using SSL. This is a default setting to ensure secure connection. |
(optional) Use SSH tunnel | Specifies if the connection should run via SSH tunnelling. If you are familiar with SSH tunnelling, you will need to provide the following additional details. Once this option is toggled, we provide our public key for download.
|
Click on "Test connection" to ensure that your connection works reliably and save your data source connection with "Connect".
Note: You can configure the data source for two different environments, Staging and Production. You can find more information about it here.
Last updated