Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Microsoft Azure Blob Storage
  3. PowerExchange for Microsoft Azure Blob Storage Configuration
  4. Microsoft Azure Blob Storage Connections
  5. Microsoft Azure Blob Storage Data Objects
  6. Microsoft Azure Blob Storage Mappings
  7. Data Type Reference

PowerExchange for Microsoft Azure Blob Storage User Guide

PowerExchange for Microsoft Azure Blob Storage User Guide

Intelligent Structure Model Data Types and Transformation Types

Intelligent Structure Model Data Types and Transformation Types

Intelligent structure model data types map to transformation data types that the Data Integration Service uses to move data across platforms.
The following table lists the intelligent structure model data types that the Data Integration Service supports and the corresponding transformation data types:
Intelligent Structure Model Complex File Data Type
Transformation Data Type
Range and Description
Array
Array
Unlimited number of characters.
Bigint
Bigint
Precision of 19 digits, scale of 0.
Datetime
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Double
Double
Precision of 15 digits.
Int
Integer
-2,147,483,648 to 2,147,483,647.
Number
Decimal
Precision 1 to 28, scale 0 to 28
String
String
1 to 104,857,600 characters
Struct
Struct
Unlimited number of characters.