Capabilities for Greenplum

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

Capture

HVR does not support Capture changes from location on Greenplum.

Repository Database

HVR does not support Repository database on Greenplum.

Integrate

HVR supports the following capabilities on Greenplum:

• Integrate changes into location (Greenplum from version 5.0.0 to version 6.9.0).
• Burst integration (Integrate with parameter Method=BURST) (Greenplum from version 5.0.0 to version 6.9.0).
• Integrate with parameter BurstCommitFrequency (Greenplum from version 5.0.0 to version 6.9.0).
• Continuous integration (Integrate with parameter Method=CONTINUOUS) (Greenplum from version 5.0.0 to version 6.9.0).
• ColumnProperties with parameter SoftDelete (Greenplum from version 5.0.0 to version 6.9.0).
• Bulk load requires a staging area (location property Staging_Directory) (Greenplum from version 5.0.0 to version 6.9.0).
• Creation and update of HVR state tables (Greenplum from version 5.0.0 to version 6.9.0).

HVR does not support the following capabilities on Greenplum:

• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration.
• Continuous integrate with parameter OnErrorSaveFailed.
• Disable/enable database triggers during integrate (with parameter NoTriggerFiring).
• Integrate with parameter DbProc.

Bi-directional Replication

HVR does not support Bi-directional Replication on Greenplum.

Refresh and Compare

HVR supports the following capabilities on Greenplum:

• hvrrefresh or hvrcompare from source location (Greenplum from version 5.0.0 to version 6.9.0).
• hvrrefresh into target location (Greenplum from version 5.0.0 to version 6.9.0).
• Isolated table hvrrefresh (option -i) into target location (Greenplum from version 5.0.0 to version 6.9.0).
• Row-wise hvrrefresh into target location (option -g) (Greenplum from version 5.0.0 to version 6.9.0).

HVR does not support the following capabilities on Greenplum:

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

Other Capabilities

HVR supports the following capabilities on Greenplum:

• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey) (Greenplum from version 5.0.0 to version 6.9.0).
• International table and column names where DBMS is not configured with UTF-8 encoding (Greenplum from version 5.0.0 to version 6.9.0).
• Treat DBMS table names and columns as case sensitive if configured (location property Case_Sensitive_Names) (Greenplum from version 5.0.0 to version 6.9.0).
• Treat DBMS schema names as case sensitive if configured (location property Case_Sensitive_Names) (Greenplum from version 5.0.0 to version 6.9.0).

HVR does not support the following capabilities on Greenplum:

• Lossless binary float datatypes. No data loss when transporting float values (because base 2 fractions are never converted to base 10). The values for these datatypes, when selected back from the database, might be slightly different from the ones that were inserted. This leads to Compare differences..