Connecting to MS SQL Server / Azure Synapse

Sisu allows you to connect to your data in MS SQL Server or Azure Synapse. The instructions are the same for both.

Related Articles:

• Understanding Data & Data Sources in Sisu
• Allowlisting Sisu Static IPs for Data Sources
• Adding & Removing a Restricted Data Source

Step 1:  Create Access to your MS SQL Server

1. Create access to your MS SQL Server.
2. Create a username and password for Sisu.
   
   

   Take note of the following information (you’ll use it in the next steps): Your Host or IP address for your SQL Server instance Port  the port is it listening on Database Name - name of the database

Step 2:  Add Azure Synapse/SQL Server in Sisu

To add Snowflake as a Data Source in Sisu:

1. In the main Sisu menu at the top of the screen, click Data sources page, then click "+ New data source".
   
   
   
   
2. Select “Axure Synapse/SQL Server” from the Select data source dropdown, and fill in the following information as described below.
   
   

   Host Name	Your Host or IP address for your SQL Server instance
   Port	(e.g., 5439)
   Database Name	(e.g., dev)
   Username	The Sisu Redshift user’s username from Step 2 (e.g., sisu)
   Password	The Sisu Redshift user’s password from Step 2
   Display Name	The name displayed in Sisu.
   Restrict Access	Check this if you want to restrict this data source to specific users

   
   
   
   

   Check Restrict Access if you want to restrict this data source to specific users.

   
   
3. Click Add.
   
   

   If you experience any issues, please contact Sisu at support@sisudata.com.