GAPTEQ supports the connection of SQL databases in Microsoft Fabric via the Service Principal. The following article describes which configurations need to be made in the Azure or Fabric Portal and how the connection works in GAPTEQ.
In this article you will read the following content:
Configurations in the Microsoft Azure Portal
Activate access for Service Principal in the Microsoft Fabric Portal
Access data to the SQL server in Fabric
Establishing a connection to the SQL database in the GAPTEQ Designer
To obtain the necessary connection information for SQL databases in Microsoft Fabric in the GAPTEQ Designer, configurations are required in the Microsoft Azure Portal (see 1.) and in the Microsoft Fabric Portal (see 2.). Further required SQL server information can be obtained directly from the Fabric platform (see 3.)
1. Configurations in the Microsoft Azure Portal
- Open the Microsoft Azure Portal and select “Microsoft Entra ID” from the left-hand menu bar.
- Via the “Add” option, you now have the option of creating an “Register an application”.
- A display name for the application must first be assigned here. This will be required later to activate the service principal in the Microsoft Fabric Portal.
Tip! The default settings can be used for the other configurations (Supported account types).
Registration generates an “Application (client) ID”. This is later used as the user name in the connection in the GAPTEQ Designer.
- The Client Secret Key can be viewed under the “Certificates & secrets” tab.
2. Activate access for Service Principal in the Microsoft Fabric Portal
- Open the Microsoft Fabric Portal (Admin Portal) to enable access for the previously registered service principal.
- To do this, set the setting “Service principals can use Fabric APIs” to “Enabled” under the menu item “Tenant settings” or “Developer settings”.
Info!
An Azure Service Principal is an identity that is created for use with applications, hosted services and automated tools to access Azure resources. This access is restricted by the roles assigned to the service principal so that you can control which resources or tiers can be accessed.
- In the next step, the user who was registered in the Azure portal in step 1 can be activated in the workspace under “Manage access” by clicking “Add”.
3. Access data to the SQL server from the Fabric platform
Additional access information to the SQL server (server address and database name) is required directly from the fabric platform so that the database connection can be established in the GAPTEQ Designer.
- To do this, go to the “Settings” of the respective database
- The server address can be determined under the menu item “Connection strings” under “Data Source”.
- The database name can also be determined under the menu item “Connections strings” under “Initial Catalog”.
4. Establish a connection to the SQL database in the GAPTEQ Designer
- Open a repository in the GAPTEQ Designer and click on the “Connections” area at the bottom left of the sidebar and then on the icon / symbol for a “new database connection”.
-
- Database system: Fabric
- Server: Connection String - Data Source from Fabric Platform (see 3.)
- Authentication: Active Directory Service Principal
- User name: Application ID (Client) from Microsoft Azure Portal (see 1.)
- Password: secret client key from Microsoft Azure Portal (see 1.)
- Database: Connection String - Initial Catalog from Fabric Platform (see 3.)
