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

Amazon Redshift V2 Connector overview

Amazon Redshift V2 Connector overview

You can use Amazon Redshift V2 Connector to securely read data from and write data to Amazon Redshift. Amazon Redshift V2 sources and targets represent records in Amazon Redshift.
You can create an Amazon Redshift V2 connection and use the connection in mappings and
mapping
tasks. You can also use the Amazon Redshift V2 connection in
elastic mappings
. For more information about
elastic mappings
, see
Administrator
and
Mappings
.
When you run an Amazon Redshift V2 mapping or
mapping
task, the Secure Agent writes data to Amazon Redshift based on the workflow and Amazon Redshift V2 connection configuration. The Secure Agent connects and writes data to Amazon Simple Storage Service (Amazon S3) through a TCP/IP network. Amazon S3 is a storage service in which you can copy data from a source and simultaneously move data to Amazon Redshift clusters. The Secure Agent issues a copy command that copies data from Amazon S3 to the Amazon Redshift target table.
You can move data from any data source to Amazon Redshift. The
Data Integration
uses the Amazon driver to communicate with Amazon Redshift.
Create a
mapping
task to process data based on the data flow logic defined in a mapping or integration template.
You can create a
mapping
task to capture changed data from the Oracle CDC source and write the changed data to an Amazon Redshift target table.