Microsoft Azure Data Lake Storage Gen2 Connector

Back Next

Data type reference

Data Integration uses the following data types in

Microsoft Azure Data Lake Storage Gen2

mappings and mapping tasks:

Microsoft Azure Data Lake Storage Gen2

native data types appear in the Source transformation

and Target transformation

when you choose to edit metadata for the fields.

Transformation data types. Set of data types that appear in the transformations. These are internal data types based on ANSI SQL-92 generic data types, which the Secure Agent uses to move data across platforms. They appear in all transformations in a mapping.

When the Secure Agent reads source data, it converts the native data types to the comparable transformation data types before transforming the data.

When the Secure Agent writes to a target, it converts the transformation data types to the comparable native data types.

The following table lists the

Microsoft Azure Data Lake Storage Gen2

data types that

Data Integration

supports and the corresponding transformation data types: