SQL database in Microsoft Fabric Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using SQL database in Microsoft Fabric for replication.
Supported Platforms
- Learn about the SQL database in Microsoft Fabric versions compatible with HVR on our Platform Support Matrix page (6.3.5 and 6.3.0).
Supported Capabilities
- Discover what HVR offers for SQL database in Microsoft Fabric on our Capabilities for SQL database in Microsoft Fabric page (6.3.5 and 6.3.0).
ODBC Connection
Since v6.3.0/6, v6.3.5/2
Microsoft ODBC Driver for SQL Server must be installed on the machine from which HVR connects to SQL database in Microsoft Fabric.
HVR uses the ODBC driver to connect to, read from, and write to SQL database in Microsoft Fabric. The connection to SQL database in Microsoft Fabric is encrypted by default.
For information about the supported ODBC driver version, refer to the HVR release notes (hvr.rel) available in the HVR_HOME directory or the downloads page.
Authentication Methods
HVR supports the following authentication methods for authenticating to SQL database in Microsoft Fabric.
Access token
Use this method to authenticate HVR to SQL database in Microsoft Fabric with an OAuth 2.0 access token. The required connection parameters are:
- OAUTH2 ENDPOINT: OAuth 2.0 token endpoint URL
- CLIENT ID: Client ID of the Microsoft Entra application
- CLIENT SECRET KEY: Client secret of the Microsoft Entra application
For more information, see Microsoft documentation for application and service principal authentication.
Microsoft Entra ID
Use this method to authenticate HVR to SQL database in Microsoft Fabric with Microsoft Entra ID authentication. The required connection parameters are:
- USER: Microsoft Entra username
- PASSWORD: Microsoft Entra user password