Microsoft APS PDW target data types
The Microsoft APS PDW database for Qlik Replicate supports most Microsoft APS PDW data types. The following table shows the Microsoft APS PDW target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate Data Types | Microsoft APS PDW Data Types |
|---|---|
|
BOOLEAN |
BIT |
|
BYTES |
VARBINARY (Length) |
|
DATE |
DATE |
|
TIME |
TIME |
|
DATETIME |
DATETIME2 (scale) |
|
INT1 |
TINYINT |
|
INT2 |
SMALLINT |
|
INT4 |
INTEGER |
|
INT8 |
BIGINT |
|
NUMERIC |
DECIMAL (p,s) |
|
REAL4 |
FLOAT (24) |
|
REAL8 |
FLOAT (53) |
|
STRING |
VARCHAR (Length) |
|
UINT1 |
TINYINT |
|
UINT2 |
SMALLINT |
|
UINT4 |
INTEGER |
|
UINT8 |
BIGINT |
|
WSTRING |
NVARCHAR (Length) |
|
BLOB |
VARBINARY (8000) |
|
NCLOB |
NVARCHAR (4000) |
|
CLOB |
VARCHAR (8000) |