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

Amazon Redshift Connector overview

You can use Amazon Redshift Connector to securely read data from or write data to Amazon Redshift. Amazon Redshift sources and targets represent records in Amazon Redshift.
You can create an Amazon Redshift connection and use the connection in
synchronization
tasks, mappings and mapping tasks. When you use Amazon Redshift objects in
synchronization
tasks, mappings, and mapping tasks, you must configure properties specific to Amazon Redshift.
Create an Amazon Redshift connection to specify the location of Amazon Redshift sources, lookups, and targets you want to include in a task. When you run an Amazon Redshift
synchronization
task, mapping, or
mapping
task, the agent writes data to Amazon Redshift based on the workflow and Amazon Redshift connection configuration. The 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 agent issues a copy command that copies data from Amazon S3 to the Amazon Redshift target table.
You can also read data from or write data to the Amazon Redshift cluster that reside in a Virtual Private Cloud (VPC). When you read data from or write data to Amazon Redshift, you can specify the Hosted Agent or the Secure Agent.
You can move data from any data source to Amazon Redshift.
Data Integration
that uses the Amazon driver to communicate with Amazon Redshift.
Informatica recommends to use Amazon Redshift V2 Connector as the new features and enhancements are provided for Amazon Redshift V2 Connector.