Search

Workflow Basics Guide

Workflow Basics Guide

10.5
- 10.4.0

Back Next

PowerExchange for Amazon S3 Connections

PowerExchange for Amazon S3 Connections

When you configure an Amazon S3 connection, you define the connection attributes that the PowerCenter Integration Service uses to connect to Amazon S3.

The following table describes the Amazon S3 connection properties:

Property	Description
Name	The name of the Amazon S3 connection.
Type	The Amazon S3 connection type.
Access Key	The access key ID used to access the Amazon account resources. Required if you do not use AWS Identity and Access Management (IAM) authentication. Ensure that you have valid AWS credentials before you create a connection.
Secret Key	The secret access key used to access the Amazon account resources. This value is associated with the access key and uniquely identifies the account. You must specify this value if you specify the access key ID. Required if you do not use AWS Identity and Access Management (IAM) authentication.
Folder Path	The complete path to the Amazon S3 objects and must include the bucket name and any folder name. Ensure that you do not use a forward slash at the end of the folder path. For example, <bucket name>/<my folder name>
Master Symmetric Key	Optional. Provide a 256-bit AES encryption key in the Base64 format when you enable client-side encryption. You can generate a key using a third-party tool. If you specify a value, ensure that you specify the Encryption Type as Client Side Encryption in the target session properties.
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 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.
Code Page	The code page compatible with the Amazon S3 source. Select one of the following code pages: MS Windows Latin 1. Select for ISO 8859-1 Western European data. UTF-8. Select for Unicode and non-Unicode data. Shift-JIS. Select for double-byte character data. ISO 8859-15 Latin 9 (Western European). ISO 8859-2 Eastern European. ISO 8859-3 Southeast European. ISO 8859-5 Cyrillic. ISO 8859-9 Latin 5 (Turkish). IBM EBCDIC International Latin-1.
Region Name	The name of the region where the Amazon S3 bucket is available. Select one of the following regions: Asia Pacific (Mumbai) Asia Pacific (Seoul) Asia Pacific (Singapore) Asia Pacific (Sydney) Asia Pacific (Tokyo) AWS GovCloud Canada (Central) China (Beijing) EU (Ireland) EU (Frankfurt) South America (Sao Paulo) US East (Ohio) US East (N. Virginia) US West (N. California) US West (Oregon) Default is US East (N. Virginia).
Formatting Options	Select a delimiter, text qualifier, or an escape character. If you want to specify a delimiter other than comma, tab, colon, and semi-colon, you must choose Other in File Formatting options. When you specify a delimiter in the Other option, the PowerCenter Integration Service might display an error message or the fields or metadata are not fetched as expected. You must follow the below guidelines when you use the Other option for delimiter in File Formatting Options: You must use a single special character excluding comma as the delimiter such as, #, @, &, or ~. You must not use multibyte characters as the delimiter. You must not use text qualifiers such as, ' and " as the delimiter. You cannot use this property when you configure an Amazon S3 connection in the Workflow Manager.

Connection Objects

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.