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
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