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