Amazon Redshift Connector Overview

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 use Amazon Redshift objects as sources and targets in Data Synchronization tasks, mappings, PowerCenter tasks, and mapping tasks. When you use Amazon Redshift objects in Data Synchronization tasks, mappings, and mapping tasks, you must configure properties specific to Amazon Redshift. When you use Amazon Redshift objects in PowerCenter tasks, you do not 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 Data Synchronization task, mapping, or Mapping Configuration 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 move data from any data source to Amazon Redshift. Informatica Cloud uses the Amazon driver to communicate with Amazon Redshift.