NOTE: The |
| Source Data Type | Supported | |
|---|---|---|
| INT | Y | Integer |
| TINYINT | Y | Integer |
| SMALLINT | Y | Integer |
| BIGINT | Y | Integer |
| FLOAT | Y | Float |
| REAL | Y | Float |
| BIT | Y | Bool |
| SMALLMONEY | Y | String |
| MONEY | Y | String |
| DECIMAL | Y | Float |
| NUMERIC | Y | String |
| DATETIMEOFFSET | Y | String |
| TIME | Y | String |
| DATE | Y | String |
| DATETIME | Y | String |
| DATETIME2 | Y | String |
| SMALLDATETIME | Y | String |
| CHAR | Y | String |
| VARCHAR | Y | String |
| NCHAR | Y | String |
| NVARCHAR | Y | String |
| SYSNAME | Y | String |
| BINARY | Y | String |
| VARBINARY | Y | String |
| UNIQUEIDENTIFIER | Y | String |
| TIMESTAMP | N | |
| GEOGRAPHY | N | |
| GEOMETRY | N | |
| HIERARCHYID | N | |
| IMAGE | N | |
| TEXT | N | |
| NTEXT | N | |
| XML | N | |
| CURSOR | N | |
| ROWVERSION | N | |
| SQL_VARIANT | N |
NOTE: By default, the maximum length of values published to VARCHAR columns is 256 characters. As needed, this limit can be changed for multiple publication targets. For more information, see Configure Application Limits. |
| SQL DW Data Type | Notes | |
|---|---|---|
| String | VARCHAR | |
| Integer | BIGINT |
|
| Float | FLOAT | |
| Bool | BIT | |
| Datetime | DATETIME2 | If a time-only value is published as an append to a pre-defined DATETIME2 column, then the output column is prepended with 1900-01-01. |
| Datetime (with time value only) | TIME | If a value is published as an append to a pre-defined TIME column, then any date information is dropped from the output. |
| Datetime | VARCHAR | If a Datetime value is published as an append to a pre-defined VARCHAR column, then the output column contains the string value of whatever appears in the Transformer page. |
| Map | VARCHAR | |
| Array | VARCHAR | |
| Date | VARCHAR | |
| All Other Data Types | VARCHAR |