Azure SQL columns mapping
Updated 26 March 2026
Type mapping
the system matches Azure SQL data types to Data Integration data types as we extract your data.
The following table shows the mapping of Azure SQL data types to Data Integration-compatible types:
| Data Integration data types | Azure SQL database Target data types |
|---|---|
| BOOLEAN | BIT |
| SHORT | SMALLINT |
| INT | INTEGER |
| LONG | BIGINT |
| FLOAT | REAL |
| DOUBLE | DOUBLEPRECISION |
| BIGDECIMAL | DECIMAL |
| LOCALDATE | DATE |
| INSTANT | DATETIMEOFFSET |
| LOCALDATETIME | DATETIME2 |
| STRING | NVARCHAR |
| JSON | NVARCHAR |
| BINARY | VARBINARY |
