Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Mapping functionality

Mapping functionality

The following table compares the mapping functionality supported by Amazon Redshift connectors:
Mapping functionality
Amazon Redshift Connector
Amazon Redshift V2 Connector
Hosted agent
Yes
Yes
Proxy server
Yes
Yes
Synchronization task
Yes
No
Mapping task
Yes
Yes (Preferred)
Elastic mappings
No
Yes
Read from Oracle CDC Sources
No
Yes
Pushdown optimization
Use an ODBC connection with
ODBC Subtype
=
Redshift
to enable source or full pushdown optimization between Amazon Redshift source and target.
  • Use an Amazon S3 V3 source connection and an Amazon Redshift V2 target connection to enable full pushdown optimization between Amazon S3 source and Amazon Redshift target.
  • Use an ODBC connection with
    ODBC Subtype
    =
    Redshift
    to pushdown optimization between Amazon Redshift source and target.
Pushdown optimization does not apply to
elastic mappings
.
Lookup transformation
Cache, uncached, and connected
Cache, uncached, connected, and unconnected
Uncached lookups do not apply to elastic mappings.
The following table lists the Amazon Redshift functionality supported by the Amazon Redshift connectors:
Amazon Redshift Functionality
Amazon Redshift Connector
Amazon Redshift V2 Connector
VPC endpoints
Yes
Yes
Redshift Spectrum
No
Yes