accoTOOL configuration for FABRIC SQL DB

Step 1: Create or Open a Fabric SQL Database

(View the guide below for creating a Fabric SQL DB if you haven't already.)

Step 2: Configure Connection Settings

1. Open the Settings menu of your Fabric SQL Database.

2. Select Connection Strings.

3. In your visual, go to the Formatting tab and click on Connection.

4. Copy and paste the Server name and Database name as shown in the image provided.

5. Enter the following credentials in the configuration fields (view the guide below below for creating a Service Principal):

   • Service Principal ID

   • Service Principal Secret

   • Tenant ID (Service Principal Tenant)

Step 3: Connect to the Database

1. Add the Schema Name.

2. Add the Table or View Name.

3. (Optional) Specify the column for update details or user info—this is defined by the measure set in the "User" field of the configuration.

4. (Optional) Specify the column for update timestamp—this indicates where the update date should go in your writeback table.