fabric-data-warehouse-configure-connection-profile
Connection Profile Name: Enter a name that uniquely identifies the external resource.
Namespace:.Select the namespace where the profile will be stored. All users who will use this profile must have READ and SELECT permissions on the namespace.
Endpoint Type: Select Fabric Data Warehouse.
Authentication Type: Select the type of authentication you want to use, then set the properties for that type as described below.
Setting Entra ID properties
Entra ID was formerly known as Azure Active Directory.
Use Connection URL: Enable this to specify only a connection URL rather than the following three properties.
Provide the full JDBC connection URL with Active Directory password for authentication using the format:
jdbc:sqlserver://;serverName=<host URL>;database=<datawarehouseName>
SQL Connection String: Enter the connection string to connect to Fabric Data Warehouse.
Warehouse Name: Enter the name of the warehouse to write to.
JDBC Properties: Optionally, add options to be appended to the SQL connection string.
After specifying the connection URL, click Sign in using Entra ID. Log in with an Entra ID organization (work) account that has the Contributor role or higher. Once you log in successfully, close the browser window, return to the connection profile page, and test the connection.
When the Entra ID access token expires (by default after one hour), applications using this connection profile will automatically switch to the new token. Shortly before the Entra ID refresh token is due to expire (by default every 90 days), click Sign in using Entra ID to update it.
Setting Microsoft Entra Service Principal properties
To use an Entra Service Principal to connect to Fabric Data Warehouse:
Register an application with the Microsoft identity platform as described in Learn / Microsoft Entra / Microsoft identity platform / Quickstart: Register an application with the Microsoft identity platform.
Go to the registered app, select API permissions, and add the Azure SQL Database (user_impersonation) permission.
Click Certificates and secrets on the left panel and click Add client secret. Make note of the client secret value as you will need to provide it in the connection profile in Striim.
Assign the app to your Fabric workspace: Go to the Fabric portal and navigate to your workspace, at the top right click Manage access, click Add people or groups and search for the app name you created earlier, choose the Contributor role, and click Add.
Set the following properties in your connection profile:
Client ID: Enter the Application (client) ID from your application's Overview page.
Client Secret: Enter the Client Secret.
SQL Connection String: Enter the connection string to connect to Fabric Data Warehouse.
Warehouse Name: Enter the name of the warehouse to write to.
JDBC Properties: Optionally, add options to be appended to the SQL connection string.
When you rotate the Client ID and Client Secret, applications using this connection profile will automatically switch to the new token.
Setting Manual OAuth properties
See Using manual OAuth with Fabric Data Warehouse. When you rotate the Client ID, Client Secret, Tenant ID, and Refresh Token, applications using this connection profile will automatically switch to the new token.