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 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.