Capabilities for Azure Synapse Analytics

Last updated on Jan 05, 2021

Contents

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:

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:

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 case sensitive (action LocationProperties /CaseSensitiveNames).
  • Always treat DBMS table names and column names case sensitive.
  • Always treat DBMS schema names case sensitive.