Location Connection for SQL database in Microsoft Fabric
This section describes the connection details required for creating a location for SQL database in Microsoft Fabric in Fivetran HVR.
For information about the prerequisites, access privileges, and other configuration requirements for creating this location, see SQL database in Microsoft Fabric Requirements.
If the managed secrets feature is enabled, the USE TOKEN INSTEAD option is displayed in the fields used for entering secrets.
| Field | Description | Equivalent Location Property |
|---|---|---|
| MICROSOFT FABRIC SQL DATABASE ENDPOINT | SQL connection endpoint of the SQL database in Microsoft Fabric. For example, | MS_Fabric_Server |
| DATABASE | Name of the SQL database in Microsoft Fabric. | Database_Name |
| AUTHENTICATION METHOD | Authentication method used by HVR to connect to SQL database in Microsoft Fabric. Available options:
| MS_Fabric_Authentication_Method |
| OAUTH2 ENDPOINT | URL used to obtain the bearer token using client credentials. Use the OAuth 2.0 endpoint. The URL must include v2.0. For example, | MS_Fabric_OAuth2_Endpoint |
| CLIENT ID | Client ID used to obtain the access token. This field is available only if the AUTHENTICATION METHOD is set to Access Token. | MS_Fabric_OAuth2_Client_Id |
| CLIENT SECRET KEY | Client secret associated with the CLIENT ID. This field is available only if the AUTHENTICATION METHOD is set to Access Token. | MS_Fabric_OAuth2_Client_Secret |
| USER | Microsoft Entra username used to connect to SQL database in Microsoft Fabric. This field is available only if the AUTHENTICATION METHOD is set to Microsoft Entra ID. | MS_Fabric_Entra_User |
| PASSWORD | Password for the Microsoft Entra USER. This field is available only if the AUTHENTICATION METHOD is set to Microsoft Entra ID. | MS_Fabric_Entra_Password |
Advanced Settings
| Field | Description | Equivalent Location Property |
|---|---|---|
| LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH | Directory path where the ODBC Driver Manager Library is installed. This field applies only to Linux/Unix operating systems. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in a non-default location, for example /opt/unixodbc, the value for this field would be /opt/unixodbc/lib. | ODBC_DM_Lib_Path |
| ODBCSYSINI | Directory path where the odbc.ini and odbcinst.ini files are located. This field applies only to Linux/Unix operating systems. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in a non-default location, for example /opt/unixodbc, the value for this field would be /opt/unixodbc/etc. | ODBC_Sysini |
| ODBC DRIVER | Name of the installed, user-defined ODBC driver used for connecting HVR to SQL database in Microsoft Fabric. | ODBC_Driver |