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

Secure Agent and Amazon Redshift integration

Secure Agent and Amazon Redshift integration

The Secure Agent uses the Amazon Redshift connection to connect to Amazon Redshift.
The following image shows how the Secure Agent connects to Amazon Redshift to read data:
The Secure Agent connects to Amazon Redshift and issues UNLOAD command to read data from Amazon Redshift to the Amazon Simple Storage Service (Amazon S3) bucket specified in the connection properties. The Secure Agent then stores data in a staging directory on the Secure Agent system over a TCP/IP network.
The following image shows how the Secure Agent connects to Amazon Redshift to write data:
The Secure Agent reads data from a staging directory on the Secure Agent system and writes data to Amazon Simple Storage Service (Amazon S3) through a TCP/IP network. The Secure Agent then issues COPY command to write data from Amazon S3 to the Amazon Redshift target table.