# 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


---

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