Redshift Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Amazon Redshift for replication.
For information about compatibility and supported versions of Redshift with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Redshift, see Capabilities for Redshift.
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 Redshift, see the Character Encodings page.
ODBC Connection
HVR uses ODBC connection to the Amazon Redshift clusters. The Amazon Redshift ODBC driver must be installed on the machine from which HVR connects to the Amazon Redshift clusters. For more information about downloading and installing Amazon Redshift ODBC driver, refer to AWS documentation. On Linux, HVR additionally requires unixODBC. 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.