Capabilities for Azure Synapse Analytics

This section lists the Capabilities of HVR when using 'Azure Synapse Analytics'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Requirements for Azure Synapse Analytics.

Capture

HVR does not support Capture changes from location on Azure Synapse Analytics.

Hub Database

HVR does not support Hub database on Azure Synapse Analytics.

Integrate

HVR supports the following capabilities on Azure Synapse Analytics:

• Integrate changes into location.
• Integrate with /Burst.
• Integrate with /BurstCommitFrequency.
• Continuous integration (Integrate without /Burst).
• Action Transform /SoftDelete.
• Creation and update of HVR state tables.

HVR does not support the following capabilities on Azure Synapse Analytics:

• Action TableProperties with /DuplicateRows for continuous integration.
• Continuous Integrate with /OnErrorSaveFailed (without /Burst).
• Disable/enable database triggers during Integrate (/NoTriggerFiring).
• Integrate with /DbProc.

Bi-directional Replication

HVR does not support Bi-directional Replication on Azure Synapse Analytics.

Refresh and Compare

HVR supports the following capabilities on Azure Synapse Analytics:

• Hvrrefresh or Hvrcompare from source location.
• Hvrrefresh into target location.
• Row-wise Hvrrefresh into target location (option -g).

Other Capabilities

HVR supports the following capabilities on Azure Synapse Analytics:

• Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey).
• International table and column names where DBMS is not configured with UTF-8 encoding.
• Treat DBMS table names and columns as case sensitive if configured (action LocationProperties /CaseSensitiveNames defined) .
• Always treat DBMS table names and column names as case sensitive, even if not configured (action LocationProperties /CaseSensitiveNames not defined) .
• Always treat DBMS schema names case sensitive.