# Connecting to Azure Synapse > Sisense enables easy and quick access to databases, tables and views contained with Azure Synapse databases. You can import your data into a Sisense ElastiCube, or connect your data to a Sisense Live model, using Live Connect. *Source: https://docs.sisense.com/main/SisenseLinux/connecting-to-azure-synapse.htm* --- Last updated: June 10, 2026 | | | | --- | --- | | [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) | | Launch     Grow    Enterprise | Cloud     On-Prem | Sisense enables easy and quick access to databases, tables and views contained with Azure Synapse databases. You can import your data into a Sisense ElastiCube, or connect your data to a Sisense Live model, using [Introducing Live Models](https://docs.sisense.com/main/SisenseLinux/live-connect.md). **Note:** Due to the fact that [Azure Synapse does not support the ESCAPE function](https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=azure-sqldw-latest), handling of special characters cannot be done and will result in returning all values. [*Connecting Data to a Sisense Live Model*](#) ## Adding an Azure Synapse Server Live Connection To add an Azure Synapse Live connection: 1. Open a live model. See [Creating Live Models and Adding Live Connections](https://docs.sisense.com/main/SisenseLinux/creating-live-models.md) for more information. 2. In the Model Editor, click ![+Data](https://docs.sisense.com/main/Resources/Images/+Data.png). The Choose Connector window is displayed. ![ConnMgmtChooseConnector](https://docs.sisense.com/main/Resources/Images/connMgmtChooseConnector.png) 3. Choose an available [managed connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#AccessingandManagingAvailableConnections), or create a [new connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#CreatingNewConnections), for **Azure Synapse**. The Azure Synapse Connect area is displayed. ![8 5azure synapse connectthumb](https://docs.sisense.com/main/Resources/Images/8-5azure-synapse-connectthumb0300.png) 4. In **Location**, enter the computer/server IP address of the database. To connect to a database running on your own computer, enter **localhost**. 5. In **User Name** and **Password**, enter your Azure Synapse database credentials. 6. In **Default Database**, enter the name of the default database you will use for authentication. The Default Database is an optional property in the connection to a data source. When specified, it acts as a starting point or shortcut, automatically selecting a database during the connection setup to streamline user workflows. **IMPORTANT:** The Default Database is not a security feature. It does not restrict Sisense users from accessing other databases within the data source. Access should be regulated through user permissions in the Azure Synapse database management system. 7. (Optional) Select **Encrypt Connection** to configure the driver to encrypt all communication with the Azure Synapse instance before sending it over the network, and then select **Trust Server Certificate**. 8. (Optional) In **Additional Parameters**, enter additional configuration options by appending key-value pairs to the connection string. Example: - Specifying application intent: `ApplicationIntent=ReadOnly` - Specifying an alternate port, such as `portNumber=1234` Examples for additional parameters can be found [here](https://www.connectionstrings.com/sql-server). 9. Click **Next**. 10. Under the **Select Data** tab, on the left side is a list of schemas located in your data source. Select the relevant schema. You can find the schema easily by searching for it through the search field at the top of the list to filter the schemas displayed. After selecting the schema, a list of the available tables and views are displayed. 11. Select a table or view. You can find the table easily by searching for it through the search field at the top of the list to filter the tables displayed. 12. Click **Done**. The table is added to the model. See [Publishing Live Models](https://docs.sisense.com/main/SisenseLinux/publishing-live-models.md) for information on how to publish the model and begin creating visualizations with it. [*Importing Into a Sisense ElastiCube*](#) **Note:** Sisense connects to your Azure Synapse database through the default port 1433. This port should be open to Sisense so a connection can be made. Contact your IT department if this port is closed. ## Importing from an Azure Synapse Database To import data from your Azure Synapse database: 1. In the Data page, open an ElastiCube or click ![+Elasticube](https://docs.sisense.com/main/Resources/Images/+Elasticube.png) to create a new ElastiCube. 2. In the Model Editor, click ![+Data](https://docs.sisense.com/main/Resources/Images/+Data.png). The Add Data dialog box is displayed. ![8 5azure synapse add ecthumb](https://docs.sisense.com/main/Resources/Images/8-5azure-synapse-add-ecthumb0300.png) 3. Click **Azure Synapse**. The Azure Synapse Connect area is displayed. ![8 5azure synapse connectthumb](https://docs.sisense.com/main/Resources/Images/8-5azure-synapse-connectthumb03001.png) 4. In **Location**, enter the computer/server IP address of the database. To connect to a database running on your own computer, enter localhost. 5. In **User Name** and **Password**, enter your Azure Synapse database credentials. 6. In **Default Database**, enter the name of the default database you will use for authentication. The Default Database is an optional property in the connection to a data source. When specified, it acts as a starting point or shortcut, automatically selecting a database during the connection setup to streamline user workflows. **IMPORTANT:** The Default Database is not a security feature. It does not restrict Sisense users from accessing other databases within the data source. Access should be regulated through user permissions in the Azure Synapse database management system. 7. (Optional) Select **Encrypt Connection** to configure the driver to encrypt all communication with the Azure Synapse instance before sending it over the network, and then select **Trust Server Certificate**. 8. (Optional) In **Additional Parameters**, enter additional configuration options by appending key-value pairs to the connection string. **Example:** - Specifying application intent: `ApplicationIntent=ReadOnly` - Specifying an alternate port, such as `portNumber=1234` Examples for additional parameters can be found [here](https://www.connectionstrings.com/sql-server). 9. Click ![Next](https://docs.sisense.com/main/Resources/Images/Next.png). A list of tables in the database are displayed. All tables and views associated with the database appear in a new window. ![8 5v7sqltablesthumb](https://docs.sisense.com/main/Resources/Images/8-5v7sqltablesthumb0300.png) 10. From the **Select Table** list, select the relevant database you want to work with, and click **Done**. To view a preview of data contained in a particular table, select the table or view in the list and in click the Preview Table. 11. After you have selected all the relevant tables, click **Done**.