DQC Logo
|

Connection to Microsoft Fabric

To connect an Microsoft Fabric 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 Microsoft Fabric connector

To begin:

  1. Go to the Data Connectors screen

  2. Click the Microsoft Fabric button

  3. Enter the connection parameters described below

undefined Required connection information

Field

Example

Description

Name

OurBestDatabase

Custom name to identify your connection

Client ID

sqladmin

A SQL user with read-only permissions

Client Secret

{your password here}

Password for the SQL user

Host

<warehouse>.datawarehouse.fabric.microsoft.com

Port

1433

Default port for Microsoft Fabric

Database name

our_best_database

Name of the target database within the Microsoft Fabric instance

.

User configuration & permissions

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

undefined Dedicated, Minimal-Privilege User

  • Avoid using admin or shared credentials

  • Create a user specific to DQC Platform access

undefined 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:

3.123.94.228

undefined Notes

Connection to Microsoft Fabric | DQC