Capabilities for Greenplum

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on Greenplum. For more information about the requirements, access privileges, and other features of HVR when using Aurora MySQL for replication, see Requirements for Greenplum.

Capture

HVR does not support Capture changes from location on Greenplum


HVR Hub

HVR does not support Hub database on Greenplum


Integrate

HVR supports the following capabilities on Greenplum:

  • Integrate changes into location (Greenplum version 4.0.0 and above)
  • Integrate with /Burst (Greenplum version 4.0.0 and above)
  • Integrate with /BurstCommitFrequency (Greenplum version 4.0.0 and above)
  • Continuous integration (Integrate without /Burst) (Greenplum version 4.0.0 and above)
  • Action Transform /SoftDelete (Greenplum version 4.0.0 and above)
  • Bulk load requires a staging area (LocationProperties /StagingDirectoryHvr) (Greenplum version 4.0.0 and above)
  • Creation and update of HVR state tables


HVR does not support the following capabilities on Greenplum:

  • 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 Greenplum


Refresh and Compare

HVR supports the following capabilities on Greenplum:


Other Capabilities

HVR supports the following capabilities on Greenplum:

  • 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


HVR does not support the following capabilities on Greenplum:

  • Lossless binary float datatypes. No dataloss when transporting float values (because base 2 fractions are never converted to base 10)