Capabilities for Greenplum

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

Capture

DSS does not support Capture changes from location on Greenplum.

Repository Database

DSS does not support Repository database on Greenplum.

Integrate

DSS 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 DSS state tables (Greenplum from version 5.0.0 to version 6.9.0).

DSS does not support the following capabilities on Greenplum:

• Append integration into TimeKey (Integrate with parameter Method=APPEND).
• 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

DSS does not support Bi-directional Replication on Greenplum.

Refresh and Compare

DSS supports the following capabilities on Greenplum:

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

DSS does not support the following capabilities on Greenplum:

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

Other Capabilities

DSS 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).

DSS 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..