Sections in this category

Connecting to MS SQL Server / Azure Synapse

  • Updated

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

 

Related Articles:

 

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.

    info_icon.png

    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".

    Data_tab_-_New_data_source.png

  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


    Add_Azure.png

    tip_icon_-_small.png Check Restrict Access if you want to restrict this data source to specific users.

  3. Click Add.

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