Configuring AWS IAM Authentication for Amazon Redshift and Amazon Redshift V2 Connectors

Back Next

Create an Amazon Redshift Connection

When you set up an Amazon Redshift connection, you must configure the connection properties.

To run a mapping on Secure Agent installed on an EC2 system, you must not provide the

Access Key ID

and

Secret Access Key

when you create an Amazon Redshift connection.

The following image shows the sample values in the Amazon Redshift connection properties:

The Secure Agent uses the

Username

Password

, and

JDBC URL

properties to validate the connection.

Provide the Amazon Redshift Role Resource Name (ARN) in the

AWS_IAM_ROLE

option in the

UnloadOptions Property File

and

CopyOptions Property File

properties when you create a task. The Secure Agent uses the Amazon Redshift Role Resource Name (ARN) associated with the IAM Role to access the data from the Amazon Redshift target. When you run the mapping task, the Secure Agent validates the IAM policy.

Create a Connection

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal