Repository Database in SQL database in Microsoft Fabric

Fivetran HVR allows you to create a repository database in SQL database in Microsoft Fabric.

It is recommended to create a new database (schema) for HVR repository. If an existing database is to be used for HVR repository, then the HVR repository tables can be separated by creating a new database schema and associating it with HVR's user as follows:

create schema schemaname;

Grants for Repository Database

The following grants are required for the repository database user in SQL database in Microsoft Fabric:

grant create table to username;
grant create procedure to username;
grant select, insert, delete, update on schema::schemaname to username;
grant control on schema::schemaname to username;
alter user username with default_schema=schemaname;

Repository Database Connection

This section describes the details required for connecting to the repository database in SQL database in Microsoft Fabric:

Field	Description	Equivalent Location Property
MICROSOFT FABRIC SQL DATABASE ENDPOINT	SQL connection endpoint of the SQL database in Microsoft Fabric. For example, `tcp:servername.database.fabric.microsoft.com,1433`.	MS_Fabric_Server
DATABASE	Name of the SQL database in Microsoft Fabric.	Database_Name
AUTHENTICATION METHOD	Authentication method for connecting HVR to SQL database in Microsoft Fabric. Available options are: Access Token`Since v6.3.0/6`: Authenticate using an OAuth 2.0 access token obtained from Microsoft Entra ID. Microsoft Entra ID`Since v6.3.0/6`: Authenticate using a Microsoft Entra username and password. For more information about these options, see the Authentication Methods section.	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, `https://login.microsoftonline.com/tenant/oauth2/v2.0/token` This field is available only if the AUTHENTICATION METHOD is set to Access Token.	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