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 connectors overview

Amazon Redshift connectors overview

You can use Amazon Redshift connectors to read data from and write data to Amazon Redshift. Use the connectors to create sources and targets that represent records in Amazon Redshift
When you use Amazon Redshift connectors to create and run a
Data Integration
task, the Secure Agent reads from and writes data to Amazon Redshift based on the taskflow and Amazon Redshift connection configuration. The Secure Agent connects reads data from and writes data to Amazon Simple Storage Service (Amazon S3) through a TCP/IP network. The Secure Agent uses the Amazon driver to communicate with Amazon Redshift.
You can move data from any data source to Amazon Redshift.
Use the following connectors to create connections and integrate data to and from Amazon Redshift:
Amazon Redshift V2 Connector
This is the recommended connector to connect to Amazon Redshift. Use Amazon Redshift V2 Connector to create a mapping or a
mapping
task.
Amazon Redshift Connector
This is an older version of Amazon Redshift Connector. Informatica recommends that you use Amazon Redshift Connector to read or write data only when you want to use a
synchronization
task.