Greenplum Requirements

This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Greenplum for replication.

Supported Platforms

• Learn about the Greenplum versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

• Discover what DSS offers for Greenplum on our Capabilities for Greenplum page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Data Management

• Learn how DSS maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported Greenplum data types and their mapping, see Data Type Mapping for Greenplum.

• Understand the character encodings DSS supports for Greenplum on the Supported Character Encodings page.

ODBC Connection

It is not required to install DSS on any of the nodes of the Greenplum cluster. DSS can be installed on a standalone machine from which it connects to the Greenplum cluster. DSS requires the DataDirect Connect XE ODBC driver for Greenplum installed (on the machine from which DSS connects to a Greenplum server).

For information about the supported ODBC driver version, refer to the DSS release notes (dss.rel) available in the DSS_HOME directory or the download page.

Limitation

• DSS does not support comparing tables with bytea data type in Greenplum version 6.

Related Articles

• Greenplum as Source
• Greenplum as Target
  • Staging for Greenplum
• Location Connection for Greenplum