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 also connect to Amazon Redshift Serverless cluster to read from or write data. You can move data from any data source to Amazon Redshift. Data Integration uses the Amazon driver to communicate with Amazon Redshift.
You can create an Amazon Redshift V2 connection and use the connection in mappings and mapping tasks. You can switch the mapping to advanced mode to include transformations and functions that enable advanced functionality. The advanced cluster can be a self-service cluster, a local cluster, or hosted on Amazon Web Services.
Create a mapping task to process data based on the data flow logic defined in a mapping or integration template. You can also create a mapping task to capture changed data from an Oracle CDC source and write the changed data to an Amazon Redshift target table.
When you run an Amazon Redshift V2 mapping or mapping 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.