SQL server datatype mapping
While extracting your data, you must match SQL Server data types to Data Integration data types. If a data type is not supported, the system automatically maps it as a String type.
The mapping of SQL Server data types to Data Integration-compatible types are available in the table below:
| SQL server type | Data Integration type |
|---|---|
| REAL | FLOAT |
| SMALLDATETIME | TIMESTAMP |
| CLOB | STRING |
| TEXT | STRING |
| CHAR | STRING |
| TINYINT | INTEGER |
| BIGINT | INTEGER |
| DATETIME2 | TIMESTAMP |
| DATE | DATE |
| TEXT | STRING |
| VARBINARY | STRING |
| NUMERIC | FLOAT |
| BIT | BOOLEAN |
| JSON | STRING |
| IMAGE | STRING |
| INTEGER | INTEGER |
| ARRAY | STRING |
| NTEXT | STRING |
| SMALLMONEY | STRING |
| DECIMAL | FLOAT |
| DATETIME | TIMESTAMP |
| MONEY | STRING |
| BINARY | STRING |
| UNIQUEIDENTIFIER | STRING |
| TIMESTAMP | STRING |
| FLOAT | FLOAT |
| BOOLEAN | BOOLEAN |
| BLOB | STRING |
| TIME | STRING |
| DATETIMEOFFSET | STRING |
| XML | STRING |
Unsupported data types
| Source data type | Target |
|---|---|
| VARIANT | All |
| GEOMETRY | All |
| GEOGRAPHY | All |
| HIERARCHYID | All |
| IMAGE | All (Includes BigQuery, Azure, PostgreSQL) |
| LONG | PostgreSQL |
| XML | PostgreSQL, BigQuery, Azure |
| BIT(n) | PostgreSQL |
| TEXT | BigQuery |
