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. You can switch the mapping to advanced mode to include transformations and functions that enable advanced functionality. 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.