You can use Amazon Redshift V2 Connector to securely read data from and write data to Amazon Redshift. Amazon Redshift V2 sources and targets represent records in Amazon Redshift.
You can create an Amazon Redshift V2 connection and use the connection in mappings and
tasks. You can also use the Amazon Redshift V2 connection in
. For more information about
When you run an Amazon Redshift V2 mapping or
task, the Secure Agent writes data to Amazon Redshift based on the workflow and Amazon Redshift V2 connection configuration. The Secure 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 Secure 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. The
uses the Amazon driver to communicate with Amazon Redshift.
task to process data based on the data flow logic defined in a mapping or integration template.
You can create a
task to capture changed data from the Oracle CDC source and write the changed data to an Amazon Redshift target table.