> For the complete documentation index, see [llms.txt](https://docs.mydbsync.com/cloud-replication-main/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mydbsync.com/cloud-replication-main/target-setup/fabric-sql.md).

# Fabric SQL

**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 SQL and enter all the configuration details like host, port, username, password, database name, and schema.

<figure><img src="/files/r5YbaYVjK0z80mBbO54B" alt=""><figcaption></figcaption></figure>

> Select AAD Password Authentication

> 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 database, then click the settings icon in the left panel

<figure><img src="/files/PtABI4sMiW1GpE38kyK4" alt=""><figcaption></figcaption></figure>

* Then select the Connection strings.

<figure><img src="/files/eM8NqZTP2H7PLmNP487f" alt=""><figcaption></figcaption></figure>

* The host name can be found after Data Source= in the connection string, for example

```
avrav7zpjxje3cthvcgnyigimac7mnyi5rj3qedi7s3gxmpkk7wm.database.fabric.microsoft.com
```

* Use port number 1433
* Use your Azure username and password for authentication
  \
  The database name can be found after Initial Catalog=, for example: Fabric sql-6f742f08-00b4-4553-91d3-839339681861

<figure><img src="/files/9QZSJ83K4lqZ0CMIqueS" 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/XFvMHsOm6VOUlAuH1zca" alt=""><figcaption></figcaption></figure>

* Click Next