Amazon S3 Connector > Data Type Reference > Data Type Reference Overview
  

Data Type Reference Overview

Data Integration uses only delimited files in synchronization tasks and mapping tasks with Amazon S3.
Data Integration uses the following data types in synchronization tasks, mappings, and mapping tasks with Amazon S3:
Amazon S3 native data types
Amazon S3 data types appear in the Fields tab for Source and Target transformations when you choose to edit metadata for the fields.
Transformation data types
Set of data types that appear in the remaining transformations. They are internal data types based on ANSI SQL-92 generic data types, which Data Integration uses to move data across platforms. Transformation data types appear in all remaining transformations in a synchronization task, mapping, or mapping task.
When Data Integration reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When Data Integration writes to a target, it converts the transformation data types to the comparable native data types.
The following table lists the Amazon S3 data types that Data Integration supports and the corresponding transformation data types:
Amazon S3 Native Data Type
Transformation Data Type
Description
String
String
1 to 104,857,600 characters