Amazon S3 Connector

Back Next

Data Type Reference Overview

Data Integration

uses only delimited files in

synchronization

tasks and

mapping

tasks with Amazon .

Data Integration

uses the following data types in

synchronization

tasks, mappings, and

mapping

tasks with Amazon :

Amazon native data types: Amazon 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 data types that

Data Integration

supports and the corresponding transformation data types:

Amazon Native Data Type	Transformation Data Type	Description
String	String	1 to 104,857,600 characters