Fabric SQL

To add a Fabric SQL destination, you will need to enter the details listed below.

• Server or host name

• Port

• Database

• Schema

Refer to the fields highlighted in the screenshot to get the host, port, database name, and schema name from the connection string.

Retrieving the host, port, database and schema

• Service principal client ID

• Service principal client secret

Refer to the fields highlighted in the screenshot to get the Service principal client ID. The Client secret can be obtained while creating the service principal account.

Retrieving the Service principal ID

• Tenant ID(from Microsoft Entra ID)

Refer to the screenshots to get the tenant ID.

Retrieving the Tenant ID

Configuration for adding a Fabric SQL writeback destination.

Fabric SQL destination