Amazon Redshift Connectors > Part I: Introduction to Amazon Redshift connectors > Connector comparison > 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)
Mapping in advanced mode
No
Yes
Read from Oracle CDC Sources
No
Yes
SQL ELT optimization
Use an ODBC connection with ODBC Subtype=Redshift to enable source or full SQL ELT optimization between Amazon Redshift source and target.
  • - Use an Amazon S3 V3 source connection and an Amazon Redshift V2 target connection to enable full SQL ELT optimization between Amazon S3 source and Amazon Redshift target.
  • - Use an ODBC connection with ODBC Subtype=Redshift to SQL ELT optimization between Amazon Redshift source and target.
Note: SQL ELT optimization does not apply to mappings in advanced mode.
Lookup transformation
Cache, uncached, and connected
Cache, uncached, connected, and unconnected
Note: Uncached lookups do not apply to mappings in advanced mode.
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