For example,

Create a
rs_odbc1
Amazon Redshift ODBC connection and specify
CQA_SCHEMA1
schema in the connection properties.
Create a
rs_odbc2
Amazon Redshift ODBC connection and specify
CQA_SCHEMA2
schema in the connection properties.

For example, create a

m_rs_pdo_crossSchema

Amazon Redshift V2 mapping.

For example, add a Source transformation. Include an Amazon Redshift V2 source object and connection

rs_odbc1

to read data using

CQA_SCHEMA1

.

For example, add a Target transformation. Include an Amazon Redshift V2 target object and connection

rs_odbc2

to write data using

CQA_SCHEMA2

.

When you run the

mapping

task, the Secure Agent reads data from the Amazon Redshift source object associated with the

CQA_SCHEMA1

schema and writes data to the Amazon Redshift V2 target object associated with

CQA_SCHEMA2

schema.