| Field | Description |
|---|---|
| Data source | Microsoft Fabric Lakehouse (SQL Analytics Endpoint) |
| Supported versions | Data Quality & Observability (self-hosted) currently ships with the Microsoft JDBC Driver for SQL Server (12.6.x). Refer to the Microsoft JDBC driver support matrix for version compatibility. |
| Connection string | jdbc:sqlserver:// |
| Packaged? |  Yes |
| Certified? | Yes |
| Supported features | |
| Estimate job | Yes |
| Analyze data | Yes |
| Schedule | Yes |
| Processing capabilities | |
| Pushdown | Yes |
| Spark agent | Yes |
| Yarn agent | Yes |
| Parallel JDBC | To be confirmed |
| Java Platform version compatibility | |
| JDK 8 |
While the Java 8 version is not officially supported, you can replace the driver in the /opt/owl/drivers/mssql folder with the Java 8 version of the supported Microsoft JDBC driver (available on the Maven Repository). |
| JDK 21 | Yes |
Yes | Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
| Yes | Connection URL | String | The connection string path of your Lakehouse connection.
When referring to the example below, replace the ${value} sections of the connection URL with your actual value.
:glasses-round: Example: jdbc:sqlserver://${fabricEndpoint}:1433;databaseName=${dbName};encrypt=true;trustServerCertificate=true;authentication=ActiveDirectoryServicePrincipal
Where ${fabricEndpoint} is the SQL connection string for your Lakehouse (for example, abc123.datawarehouse.fabric.microsoft.com). Find it in the Fabric portal under your Lakehouse item's Settings > SQL analytics endpoint.
Yes | Driver Name | String | The driver class name of your Lakehouse connection.
com.microsoft.sqlserver.jdbc.SQLServerDriver
Yes | Port | Integer | The port number used to establish a connection.
The default port is 1433
No | Limit Schemas | Option | Allows you to manage usage and restrict visibility to only the necessary schemas in the Explorer tree.
See Limiting schemas to learn how to limit schemas from the Connection Management page.
Limit Schemas has not been tested for Microsoft Fabric connections.
No | Source Name | String | N/A |
| No | Target Agent | Option | The [Agent](/data-quality-self-hosted/installation/agent.md) that submits your Spark job for processing. |
| Yes | Auth Type | Option | The method to authenticate your connection. See **Authentication** below for more information. For Microsoft Fabric, **Username/Password** is the tested and recommended authentication type. Other types listed in the Authentication section may be available but have not been validated. |
| No | Properties | String | The configurable driver properties for your connection. Multiple properties must be semicolon-delimited, and each property=value pair, including the last one, must end with a semicolon (;). `abc=123;test=true;` |
### Authentication
This data source supports the following authentication types:
* Username/Password
* Password Manager
* Active Directory MSI
* Active Directory Password
* Active Directory Service Principal
* Kerberos Password Manager
* Kerberos Keytab
* Kerberos Password
* NTLM
* Password TGT Cache
{% hint style="info" %}
For Microsoft Fabric, only **Username/Password** authentication was tested. Other authentication types listed above may work but have not been validated.
{% endhint %}
| Required | Field | Description |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------- | -------------------------------------------------- |
| Yes | Username | The username for your Microsoft Fabric connection. |
| Yes | Password | The password for your Microsoft Fabric connection. |
### Known limitations
* The SQL Analytics Endpoint is read-only. Write operations (INSERT, CREATE TABLE) are not supported.
* Because the endpoint is read-only, Archive Break Records are not supported for this connection.
* Columns whose names start with a special character or a number may cause job creation to fail in both Pullup and Pushdown modes.
* Metadata fields (for example, Number of Columns and Creation Date) may appear as "N/A" in Pushdown jobs because the dm\_db\_partition\_stats dynamic management view is not supported in Microsoft Fabric.
{% endtab %}
{% tab title="Warehouse" %}
## Connecting to Microsoft Fabric Warehouse
This section contains details for connecting to a Microsoft Fabric Warehouse. Microsoft Fabric Warehouse is a fully transactional, T-SQL data warehouse in Microsoft Fabric. It connects to Data Quality & Observability (self-hosted) using the packaged Microsoft SQL Server JDBC driver and Active Directory Service Principal authentication.
### General information
| Field | Description |
|---|---|
| Data source | Microsoft Fabric Warehouse |
| Supported versions | Data Quality & Observability (self-hosted) currently ships with the Microsoft JDBC Driver for SQL Server (12.6.x). Refer to the Microsoft JDBC driver support matrix for version compatibility. |
| Connection string | jdbc:sqlserver:// |
| Packaged? | Yes |
| Certified? | Yes |
| Supported features | |
| Estimate job | Yes |
| Analyze data | Yes |
| Schedule | Yes |
| Processing capabilities | |
| Pushdown | Yes |
| Spark agent | Yes |
| Yarn agent | Yes |
| Parallel JDBC | To be confirmed |
| Java Platform version compatibility | |
| JDK 8 |
While the Java 8 version is not officially supported, you can replace the driver in the /opt/owl/drivers/mssql folder with the Java 8 version of the supported Microsoft JDBC driver (available on the Maven Repository). |
| JDK 21 | Yes |
Yes | Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
| Yes | Connection URL | String | The connection string path of your Warehouse connection.
When referring to the example below, replace the ${value} sections of the connection URL with your actual value.
:glasses-round: Example: jdbc:sqlserver://${fabricEndpoint}:1433;databaseName=${dbName};encrypt=true;trustServerCertificate=true;authentication=ActiveDirectoryServicePrincipal
Where ${fabricEndpoint} is the SQL connection string for your Warehouse (for example, abc123.datawarehouse.fabric.microsoft.com). Find it in the Fabric portal under your Warehouse item's Settings > SQL analytics endpoint. For Pushdown connections, some deployments use database=${dbName} in place of databaseName=${dbName}.
Yes | Driver Name | String | The driver class name of your Warehouse connection.
com.microsoft.sqlserver.jdbc.SQLServerDriver
Yes | Port | Integer | The port number used to establish a connection.
The default port is 1433
No | Limit Schemas | Option | Allows you to manage usage and restrict visibility to only the necessary schemas in the Explorer tree.
See Limiting schemas to learn how to limit schemas from the Connection Management page.
Limit Schemas has not been tested for Microsoft Fabric connections.
No | Source Name | String | N/A |
| No | Target Agent | Option | The [Agent](/data-quality-self-hosted/installation/agent.md) that submits your Spark job for processing. |
| Yes | Auth Type | Option | The method to authenticate your connection. See **Authentication** below for more information. For Microsoft Fabric, **Username/Password** is the tested and recommended authentication type. Other types listed in the Authentication section may be available but have not been validated. |
| No | Properties | String | The configurable driver properties for your connection. Multiple properties must be semicolon-delimited, and each property=value pair, including the last one, must end with a semicolon (;). `abc=123;test=true;` |
### Authentication
This data source supports the following authentication types:
* Username/Password
* Password Manager
* Active Directory MSI
* Active Directory Password
* Active Directory Service Principal
* Kerberos Password Manager
* Kerberos Keytab
* Kerberos Password
* NTLM
* Password TGT Cache
{% hint style="info" %}
For Microsoft Fabric, only **Username/Password** authentication was tested. Other authentication types listed above may work but have not been validated.
{% endhint %}
| Required | Field | Description |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------- | -------------------------------------------------- |
| Yes | Username | The username for your Microsoft Fabric connection. |
| Yes | Password | The password for your Microsoft Fabric connection. |
### Known limitations
* Metadata fields (for example, Number of Columns and Creation Date) appear as "N/A" in Pushdown jobs because the dm\_db\_partition\_stats dynamic management view is not supported in Fabric Warehouse.
* Correlation results appear as "N/A" in Pushdown jobs due to an arithmetic overflow limitation.
* Archive Break Records are not supported for Fabric Warehouse connections (the same limitation as SQL Server Pushdown).
* Columns whose names start with a special character or a number may cause job creation to fail in both Pullup and Pushdown modes.
{% endtab %}
{% endtabs %}