Amazon S3 Connector

Back Next

Amazon S3 Sources in Mapping

To read data from Amazon S3, configure an Amazon S3 object as the Source transformation in a mapping.

Specify the name and description of the Amazon S3 source. Configure the source and advanced properties for the source object. When you create a task with Amazon S3 as lookup, the lookup condition does not get applied.

The following table describes the source properties that you can configure in a Source transformation:

Property	Description
Connection Name	Name of the source connection.
Source Type	Source type. Select one of the following types: Single Object. Parameter. Select Parameter to define the source type when you configure the mapping task.
Object	Source object for the mapping.
Formatting Options	Amazon S3 format options. Opens the Formatting Options dialog box to define the format of the file. Default is delimited. Configure the following format options: Delimiter: Delimiter character. You can configure other parameters such as comma, tab, colon, semicolon, or others. Text Qualifier: Character to qualify text. You can configure other parameters such as single quote or double quote.

The following table describes the advanced source properties that you can configure in a Source transformation:

Property	Description
Enable Downloading S3 File in Multiple Parts	Downloads large Amazon S3 objects in multiple parts. The Secure Agent downloads the object in multiple parts from Amazon S3. When the file size of an Amazon S3 object is greater than 5 MB, you can choose to download the object in multiple parts in parallel.
Header Line Number	Amazon S3 Connector does not honor this property.
Read Data From Line	Specify the line number from where you want the Secure Agent to read data. Default is 1. To read data from the header, the value of the Header Line Number and the Read Data From Line fields should be the same.
Staging File Location	Amazon S3 staging directory. When you run a task in Secure Agent runtime environment, specify a directory path that is available on the corresponding Secure Agent machine in the runtime environment. When you specify the directory path, the Secure Agent create folders depending on the number of partitions that you specify in the following format: InfaS3Staging<00/11><timestamp>_<partition number> where, 00 represents read operation and 11 represents write operation. For example, InfaS3Staging000703115851268912800_0 The temporary files are created within the new directory. When you specify a directory name, if a folder with same name already exists, the Secure Agent deletes the contents of the folder. You must have the write permission for the specified location. If you do not specify a directory path, the Secure Agent uses a temporary directory as the staging file location. When you run a task in Hosted Agent runtime environment, leave the staging directory location blank. The Hosted Agent creates a directory at a temporary location.
Part Size	Specifies the part size of an object. Default is 5 MB.
Tracing Level	Sets the amount of detail that appears in the log file. You can choose terse, normal, verbose initialization or verbose data. Default is normal.