Connection to Azure Synapse

To connect an Azure Synapse database to the DQC Platform, you’ll need to provide connection credentials for a read-only SQL user and whitelist the platform’s IP. This guide explains all necessary steps.

Add an Azure Synapse connector

To begin:

Go to the Data Connectors screen
Click the Azure Synapse button
Enter the connection parameters described below

Select Azure Synapse to begin configuring your database connection

Required connection information

Field	Example	Description
Name	`OurBestDatabase`	Custom name to identify your connection
User	`sqladmin`	A SQL user with read-only permissions
Password	`{your password here}`	Password for the SQL user
Host	`dbmsname.database.windows.net`	Usually in the format: `<name>.database.windows.net`
Port	`1433`	Default port for Azure Synapse
Database name	`our_best_database`	Name of the target database within the Azure Synapse instance

User configuration & permissions

We recommend creating a dedicated SQL user for the DQC Platform connection with read-only access.

Dedicated, Minimal-Privilege User

Avoid using admin or shared credentials
Create a user specific to DQC Platform access

Assign Read-Only Role

In SQL Server Management Studio or via script, grant the following:

USE [your_database];
CREATE USER [dqcreader] FOR LOGIN [dqcreader_login];
ALTER ROLE db_datareader ADD MEMBER [dqcreader];

Whitelist the DQC Platform IP Address

To allow inbound connections from the DQC Platform, whitelist the following static IP in your Azure Synapse firewall settings:

3.123.94.228

Notes

TLS encryption is used by default for all Azure Synapse connections
Ensure that the SQL server allows public access, or configure a private endpoint with the same IP allowance
Learn more: Supported data sources, Connection to PostgresSQL, Data source access permissions