# Connect Soda to Microsoft Fabric

> For Soda to run quality scans on your data, you must configure it to connect to your data source.\
> To learn how to set up Soda and configure it to connect to your data sources, see [Get started](https://docs.soda.io/soda-documentation/soda-v3/quick-start-sip/setup-guide).

## Connection configuration reference

Install package: `soda-fabric`

Soda support for Fabric data source is based on `soda-sqlserver` package.

```yaml
data_source my_datasource_name:
  type: fabric
  host: host
  port: '1433'
  username: simple
  password: simple_pass
  database: database
  schema: dbo
  trusted_connection: false
  encrypt: false
  trust_server_certificate: false
  driver: ODBC Driver 18 for SQL Server
  scope: DW
  connection_parameters:
    multi_subnet_failover: true
  authentication: sql
```

| Property                   | Required | Notes                                                                                                                                                                                                                                                                                                                    |
| -------------------------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| type                       | required | Identify the type of data source for Soda.                                                                                                                                                                                                                                                                               |
| host                       | required | Provide a host identifier.                                                                                                                                                                                                                                                                                               |
| port                       | optional | Provide a port identifier. You can remove the `port` config setting entirely. Default: `1433`.                                                                                                                                                                                                                           |
| username                   | required | Use system variables to retrieve this value securely.                                                                                                                                                                                                                                                                    |
| password                   | required | Use system variables to retrieve this value securely.                                                                                                                                                                                                                                                                    |
| database                   | required | Provide an identifier for your database.                                                                                                                                                                                                                                                                                 |
| schema                     | required | Provide an identifier for the schema in which your dataset exists.                                                                                                                                                                                                                                                       |
| trusted\_connection        | optional | Indicate connection trustworthiness by providing a boolean value: `true` or `false`. The default value is `false`. Set to `true` if you are using Active Directory authentication.                                                                                                                                       |
| encrypt                    | optional | Indicate the encryption status by providing a boolean value: `true` or `false`. The default value is `false`.                                                                                                                                                                                                            |
| trust\_server\_certificate | optional | Specifies whether encryption occurs if there is no verifiable server certificate. Provide a boolean value: `true` or `false`. The default value is `false`.                                                                                                                                                              |
| driver                     | optional | Use this config setting to specify the ODBC driver version you use. For example, `SQL Server Native Client 11.0` or `ODBC Driver 18 for SQL Server`.                                                                                                                                                                     |
| scope                      | optional | Access token scope.                                                                                                                                                                                                                                                                                                      |
| multi\_subnet\_failover    | optional | Enable MultiSubnetFailover; see [MS documentation](https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/sqlclient-support-for-high-availability-disaster-recovery#connecting-with-multisubnetfailover).                                                                                                    |
| authentication             | optional | Authentication method to use. Supported values: `sql`, `activedirectoryinteractive`, `activedirectorypassword`, `activedirectoryserviceprincipal`, `activedirectory`, `auto`, `cli`, `environment`, `synapsespark`, and `fabricspark`. The default value is `sql`, which uses `username` and `password` to authenticate. |

## Test the data source connection <a href="#test-the-data-source-connection" id="test-the-data-source-connection"></a>

To confirm that you have correctly configured the connection details for the data source(s) in your configuration YAML file, use the `test-connection` command. If you wish, add a `-V` option to the command to return results in verbose mode in the CLI.

```sh
soda test-connection -d my_datasource -c configuration.yml -V
```