PowerExchange for Amazon Redshift User Guide for PowerCenter

Back Next

Import Amazon Redshift Objects

You can import Amazon Redshift source and target objects before you create a mapping.

Start PowerCenter Designer, and connect to a PowerCenter repository configured with an Amazon Redshift instance.

Open a source or target folder.

Select

Source Analyzer

Target Designer

Click

Sources

Targets

, and then click

Import from AmazonRSCloud Adapter

When you configure pushdown optimization, click

Import from Database

to import the source or target object.

For information about pushdown optiimization, see Amazon Redshift Pushdown Optimization Overview.

The

Establish Connection

dialog box appears.

Specify the following information and click

Connect

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.

Click

Select the table that you want to import, and then click

Finish

. If you want to see the table metadata, select the table, and click the table name.

When you import objects from Amazon Redshift, you cannot import related objects as a source.