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.