# 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 

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