Fabric Data Warehouse

To set up your Database instance, follow the steps below:

  • Log in to the DBSync Cloud Replication instance

  • To configure, navigate to the Database tab.

  • Click the Database icon from the top navigation toolbar

  • To start with, select Fabric Warehouse and enter all the configuration details like host, port, username, password, database name, and schema.

How to get Fabric SQL details

  • Log in to the Azure portal and open your Fabric workspace at: https://app.fabric.microsoft.com/

  • Create a warehouse inside the workspace, then click the settings icon in the left panel

  • Then select the Connection strings.

  • Copy the SQL connection string to obtain the host name. For example:

avrav7zpjxje3cthvcgnyigima-c7mnyi5rj3qedi7s3gxmpkk7wm.datawarehouse.fabric.microsoft.com
  • Use port number 1433

  • Use your Azure username and password for authentication

    1. The database name can be identified in the URL, immediately after warehouses/. For example: 3506a9db-712c-476d-ba43-695546e2ed8e

  • Once the user enters all the details, the URL details will get auto-filled.

  • Click Save

  • You can save and test your Database connection.

  • Click Next

  • You can find login details by logging into the Azure portal and navigating to

  • Azure Synapse Analytics -> SQL Pool -> Select your database -> Select connection string

Note it is required to use Azure Blob storage when using Fabric data warehouse

Steps to Obtain the Access Key and Connection String for Using Azure Blob Storage.

Step 1- Log in to your Azure portal

Step 2- On the home screen, select the Storage account from Azure services

Step 3- Inside Storage accounts, select the desired storage you want to connect with

Step 4- Inside the selected storage, click on the access key from left-hand panel

Step 5 - Copy the Key and connection string and paste them into the given space on the DBSync Database connection page

Last updated