Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

PowerExchange for Amazon Redshift Connections

PowerExchange for Amazon Redshift Connections

When you configure an Amazon Redshift connection, you define the connection attributes that the PowerCenter Integration Service uses to connect to the Amazon Redshift.
The following table describes the application connection properties:
Property
Description
Name
Name of the Amazon Redshift connection.
Type
The AmazonRSCloudAdapter connection type.
User Name
User name to access the Amazon Redshift database.
Password
Password for the Amazon Redshift database user name.
The following table describes the Amazon Redshift connection attributes:
Property
Description
Schema
Schema name for the Amazon Redshift tables.
When you import objects from
AmazonRSCloudAdapter
in the PowerCenter Designer, the table names are listed in an alphabetical order.
Default is public.
The public schema might not work for all the Amazon Redshift tables.
AWS Access Key ID
Amazon S3 bucket access key ID.
AWS Secret Access Key
Amazon S3 bucket secret access key ID.
Master Symmetric Key
Optional. Amazon S3 encryption key.
Provide a 256-bit AES encryption key in the Base64 format.
Customer Master Key ID
Optional. Specify the customer master key ID or alias name generated by AWS Key Management Service (AWS KMS).
You must generate the customer master key ID for the same region where Amazon S3 bucket reside. You can specify any of the following values:
Customer Generated Customer Master Key
Enables client-side or server-side encryption.
Default Customer Master Key
Enables client-side or server-side encryption. Only the administrator user of the account can use the default customer master key ID to enable client-side encryption.
JDBC URL
Amazon Redshift connection URL.
Number of bytes needed to support multibytes for varchar
Not applicable.
This property is not supported as you cannot use the
Create Target
option from the target session properties on an Amazon Redshift target using the PowerCenter Client.