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

> ![](https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FC7aY6jfRHUBciLxw2M91%2Fimage.png?alt=media\&token=655b8e76-fb7e-48f4-8d0e-d2f8139b8878)
>
> How to get Fabric SQL details&#x20;

* Log in to the Azure portal and open your Fabric workspace at:[ https://app.fabric.microsoft.com/](https://app.fabric.microsoft.com/)
* Create a warehouse inside the workspace, then click the settings icon in the left panel

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FLtskmgPjFsuuOCBzazbn%2Fimage.png?alt=media&#x26;token=4e62e12f-7e25-4647-ab25-01ff3d1c7c68" alt=""><figcaption></figcaption></figure>

* 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

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FC8QbDeYGW0DmCGtUsIBf%2Fimage.png?alt=media&#x26;token=96a31e8c-f211-44ef-914a-c8ec3eb2aa49" alt=""><figcaption></figcaption></figure>

* Once the user enters all the details, the URL details will get auto-filled.
* Click Save
* You can save and test your Database connection.

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FfECbkxADFTnCYp4KPUiE%2Fimage.png?alt=media&#x26;token=66487e25-23f2-4f2f-95f7-872614d24b12" alt=""><figcaption></figcaption></figure>

* Click Next
