Capabilities for SQL database in Microsoft Fabric

This section lists the Capabilities of Fivetran HVR when using 'SQL database in Microsoft Fabric'. For more information about the pre-requisites, access privileges, and other configuration requirements, see SQL database in Microsoft Fabric Requirements.

Capture

HVR does not support Capture changes from location on SQL database in Microsoft Fabric.

Repository Database

HVR supports Repository database on SQL database in Microsoft Fabric.

Integrate

HVR supports the following capabilities on SQL database in Microsoft Fabric:

• Integrate changes into location.
• Burst integration (Integrate with parameter Method=BURST).
• Integrate with parameter BurstCommitFrequency.
• Continuous integration (Integrate with parameter Method=CONTINUOUS).
• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration.
• Continuous integrate with parameter OnErrorSaveFailed.
• ColumnProperties with parameter SoftDelete.
• Creation and update of HVR state tables.
• Integrate with parameter DbProc.

HVR does not support the following capabilities on SQL database in Microsoft Fabric:

• Append integration into TimeKey (Integrate with parameter Method=APPEND).
• Disable/enable database triggers during integrate (with parameter NoTriggerFiring).

Bi-directional Replication

HVR does not support Bi-directional Replication on SQL database in Microsoft Fabric.

Refresh and Compare

HVR supports the following capabilities on SQL database in Microsoft Fabric:

• hvrrefresh or hvrcompare from source location.
• hvrrefresh into target location.
• Isolated table hvrrefresh (option -i) into target location.
• Row-wise hvrrefresh into target location (option -g).
• Disable/enable foreign keys from table to others during hvrrefresh (option -F).
• Disable/enable triggers during hvrrefresh (option -f).
• Identity columns.
• Select data with 'snapshot' SQL isolation level (hvrrefresh option -Msnapshot).

HVR does not support the following capabilities on SQL database in Microsoft Fabric:

• Bulk load of multiple slices of same table can be done in parallel.

Other Capabilities

HVR supports the following capabilities on SQL database in Microsoft Fabric:

• Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc).
• DbObjectGeneration with parameter IncludeSQLFile.
• International table and column names where DBMS is not configured with UTF-8 encoding.
• Always treat DBMS table names and column names as case sensitive, even if not configured (equivalent to location property Case_Sensitive_Names always set to TRUE) .
• Always treat DBMS schema names case sensitive.

HVR does not support the following capabilities on SQL database in Microsoft Fabric:

• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey).