SAP Connector > SAP data type reference > SAP data type reference overview
  

SAP data type reference overview

Data Integration uses the following data types in mappings, synchronization tasks, and mapping tasks with SAP:
Native data types
Native data types are data types specific to the source and target databases or flat files. They appear in non-SAP sources and targets in the mapping.
SAP data types
SAP data types appear in the Fields tab for Source and Target transformations when you choose to edit metadata for the fields. SAP performs any necessary conversion between the SAP data types and the native data types of the underlying source database tables.
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 mapping, synchronization task, 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.