Welcome to the Microsoft Fabric Connector setup guide! This document serves as a comprehensive guide for configuring Microsoft Fabric to integrate seamlessly with Savant using Azure AD App registration and JDBC.
Features
Read data from MS Fabric Data warehouse
Writing analysis outcome to MS Fabric
Requirements
Admin access to Azure AD (to register applications and configure permissions)
Access to Microsoft Fabric with ability to create or manage a Warehouse
Connection Methods
Savant supports secure authentication to Fabric using Azure AD App Registration + JDBC.
Azure AD OAuth: (Client ID, Client Secret, Tenant ID)
This step-by-step guide ensures you can efficiently set up your environment for optimal data integration.
Step 1: Create Azure AD App Registration
Go to Azure Portal
Navigate to Azure Active Directory → App registrations → New registration
Configure the app:
Name: Fabric-SQL-JDBC-App (or your preference)
Supported account types: Accounts in this organizational directory only
Redirect URI: Platform = Web, URI =
http://localhost:8080/callback(for testing)
Click Register
Save these values:
Application (client) ID: e.g.,
12345678-1234-1234-1234-123456789012Directory (tenant) ID: e.g.,
87654321-4321-4321-4321-210987654321
Step 2: Configure App Permissions
In your app registration, go to API permissions
Click Add a permission
Choose APIs my organization uses
Search for Azure SQL Database
Select Delegated permissions
Check:
user_impersonationClick Add permissions
Step 3: Create Client Secret
Go to Certificates & secrets
Click New client secret
Description:
JDBC AccessExpiry: Choose appropriate duration
Click Add
Copy the secret value now (it will not be visible again)
Step 4: Set Up Your Fabric Warehouse
Go to Microsoft Fabric
Create or select your workspace
Create a Warehouse (not Lakehouse):
Click New → Warehouse
Give it a name (e.g.,
MyWarehouse)
Once created, get the SQL connection string:
Open the Warehouse
Click Settings (gear icon)
Copy the SQL connection string (e.g.,
xxxxx.datawarehouse.fabric.microsoft.com)
Step 5: Configure the connector in Savant
In Savant, go to Connections → Add System → Microsoft Fabric.
You’ll need to provide:
Client ID*: From Azure AD App Registration
Client Secret*: From Azure AD App (Certificates & secrets)
Tenant ID*: Directory (tenant) ID from Azure AD
SQL connection string*: From Fabric Warehouse settings
Warehouse*: Name of your Fabric Warehouse
Click Authenticate. On success, Savant will validate the connection and list available schemas/tables.