Azure Synapse SQL

Description

Used to connect to Azure Synapse SQL.

Connection String Templates

Template Name Description
Azure Synapse SQL The standard connection string for connecting to an Azure Synapse SQL instance, which requires the server, database name, and username and password. You can choose to add your username and password to the connection string or the separate fields available above the connection string field.

You can copy the connection string template below into the connection string field in Loome Monitor and then replace the placeholders with your own details.

Template Example
Server=YOUR_SERVER,1433;Initial Catalog=YOUR_DATABASE_NAME;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30; Server=tcp:loome-sample-synapse.sql.azuresynapse.net,1433;Initial Catalog=Loome-Sample;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

Connection Notes

  • Support for renaming a column is not available in Azure Synapse Analytics GA as of February 2021. Thus renaming an existing column, in a custom field or in a source data column, may not work when using Azure Synapse Analytics as a target connection.