Redshift Requirements

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

Supported Platforms

• Learn about the Redshift 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 Redshift on our Capabilities for Redshift 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 Redshift data types and their mapping, see Data Type Mapping for Redshift.

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

ODBC Connection

DSS uses ODBC connection to the Amazon Redshift clusters. The Amazon Redshift ODBC driver must be installed on the machine from which DSS connects to the Amazon Redshift clusters. For more information about downloading and installing Amazon Redshift ODBC driver, refer to AWS documentation. On Linux, DSS additionally requires unixODBC. 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.

Related Articles

• Redshift as Target
  • Staging for Redshift
• Location Connection for Redshift