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

> ![](/files/I0mnaaO1rjKNVx6jqFZN)
>
> How to get Fabric SQL details 

* 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="/files/FgYytVXuy2MO6aC3UAgX" 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="/files/xEj5UTnKmpl8pQzzPLPQ" 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="/files/u5pKV5VWKTUzq56ZwLIF" alt=""><figcaption></figcaption></figure>

* Click Next
* You can find login details by logging into the Azure portal and navigating to&#x20;
* Azure Synapse Analytics -> SQL Pool  -> Select your database -> Select connection string&#x20;

![](https://lh6.googleusercontent.com/Hxuzou_LXjlL8zDL2h8Q8iZ8I6ubvB_eWmJ4UqW6WWD2hAhUMlvFM5bsxmGFIxfncKljJapxkKEURhH_KKDuHgHKVNvi0iODLX2yosxq0VxCK_XyKgYXZt5JxAB83n7MxIhrSJCFFNC7BM84kCQATqE)

> **Note it is required to use Azure Blob storage when using Fabric data warehouse**&#x20;

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

**Step 1- Log in to your** [**Azure portal**](https://login.microsoftonline.com/organizations/oauth2/v2.0/authorize?redirect_uri=https%3A%2F%2Fportal.azure.com%2Fsignin%2Findex%2F\&response_type=code%20id_token\&scope=https%3A%2F%2Fmanagement.core.windows.net%2F%2Fuser_impersonation%20openid%20email%20profile\&state=OpenIdConnect.AuthenticationProperties%3DQKAF7iE5hiUvzXXH_lVZu0ytKIsIuKOazTwX06t762bl7KCx3bSDw4RElkaJ-geBfgdrRD2wdrf_EtOSmuPX6vZIK1HhdRSEtUM_Yps2pk-z3QrnleGLWnxsDo11_c6zGNgct7YIAssWziJYe3AMN1O78JUb0040gXx162ucAyZHkIK6jldgy7Jdi_5VUVHt6gsLZywX7QwzTtN0FOFRzrDXQ7ui8Ap3sQatVHaHSLlNXH-9amZ3b3qvBQuX9R0DNSAG7OPQ-KZNYVaJD77jJkvJGmx3BGdpvyD9-6bnxnHGm6h6r5GHnIpc1oVr-MukZSCFjdntXtIl44QBSRJJqqCGU6KV6DdGlJMxC4p8KnzRtEpvAYyWxP3NeAtuDkwwIaijxD8whuZOeKxROLqqAHu5tOee01bzTSDbxF0DvxNJ7X1HIXhLfT_xNz4EEMv0xg0MEW2ZtKey7O6M13J6K0vsYYuN2Zq1zDdPuUtcQp4\&response_mode=form_post\&nonce=637998796405180311.YmQwOTM3ZTYtNjk4NS00MGNmLTk3MWEtNDRiZDc2MDcyYThlY2UwMjQzMmItZjhhNi00MTBmLTgwMTItMmU2MzlmYTM5ZWQw\&client_id=c44b4083-3bb0-49c1-b47d-974e53cbdf3c\&site_id=501430\&client-request-id=e546651e-772c-4c28-a231-b83a7765db72\&x-client-SKU=ID_NET472\&x-client-ver=6.16.0.0\&sso_reload=true)

**Step 2- On the home screen, select the Storage account from Azure services**&#x20;

![](https://help.mydbsync.com/docs/download/attachments/68878348/storage%20account.PNG?version=1\&modificationDate=1675345016000\&api=v2)

\
**Step 3- Inside Storage accounts, select the desired storage you want to connect with**&#x20;

![](https://lh3.googleusercontent.com/0_gElMUH2VePDMSXwFnYU9fnHBc0n5WOFJX9yPkRv_EXlFwKJircWV3NiawpRcRX_PIUt3YcxSNLjUmruTnHYPM80seSN3UFqESri9yVKTcndKwtIeVpbH3S2bUDuvwbl6CL7oJfcGdhWVqa-2MsG_8)

**Step 4- Inside the selected storage, click on the access key from left-hand panel**&#x20;

![](https://lh4.googleusercontent.com/60cewetNKOK_DmQd19Ht0Ae-iHgs71QJW0N-7Ju6NvEIFiyEFvX_BTW_hPSGAUzG5G6LOLKsBPqh_JWEGinrI8cX3A6x8goIaIPySfbtrGHbKku1ArCM17DaFuhrGVY3s1iWX1d1e6dwKiMP-g4IQmE)

**Step 5 - Copy the Key and connection string and paste them into the given space on the DBSync Database connection page**\
![](https://lh3.googleusercontent.com/ZESkCMlBEf0WEWL30Bgh_cEgXpfxWEWiOhg8tycsXJGC0i475EEpv7OZevcD2DW5pqyPUk1eALiJRE5NscXpxPEf8GElr-ksYkYtaD_RbRQB-e4DvEIHHsYXvYgAPDn-VQgZMRVC5rW7wnGnVJ6eREw)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-replication-main/target-setup/fabric-data-warehouse.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.