Greenplum Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Greenplum for replication.
For information about compatibility and supported versions of Greenplum with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Greenplum, see Capabilities for Greenplum.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by HVR on Greenplum, see the Character Encodings page.
ODBC Connection
It is not required to install HVR on any of the nodes of the Greenplum cluster. HVR can be installed on a standalone machine from which it connects to the Greenplum cluster. HVR requires the DataDirect Connect XE ODBC driver for Greenplum installed (on the machine from which HVR connects to a Greenplum server).
For information about the supported ODBC driver version, refer to the HVR release notes (hvr.rel) available in the HVR_HOME directory or the download page.
Limitation
- HVR does not support comparing tables with bytea data type in Greenplum version 6.