Azure SQL columns mapping
Type mapping
We match 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 datatypes |
|---|---|
| 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 |
