Supported data types
The Microsoft Azure Synapse Analytics Replicate endpoint supports most Microsoft Azure Synapse Analytics data types. The following table shows the Microsoft Azure Synapse Analytics 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 Azure Synapse Analytics Data Types |
|---|---|
|
BOOL |
BIT |
|
BYTES |
If length is => 1 and =< 8000, then: VARBINARY (Length in Bytes) If length is => 8001 and =< 2147483647, then: VARBINARY (8000) |
|
DATE |
DATE |
|
TIME |
TIME |
|
DATETIME |
DATETIME2 (s) |
|
INT1 |
SMALLINT |
|
INT2 |
SMALLINT |
|
INT4 |
INTEGER |
|
INT8 |
BIGINT |
|
NUMERIC |
DECIMAL (p,s) |
|
REAL4 |
FLOAT(24) |
|
REAL8 |
FLOAT(53) |
|
STRING |
If length is => 1 and =< 8000, then: VARCHAR (Length in Bytes) If length is => 8001 and =< 2147483647, then: VARCHAR (8000) |
|
UINT1 |
TINYINT |
|
UINT2 |
SMALLINT |
|
UINT4 |
INTEGER |
|
UINT8 |
BIGINT |
|
WSTRING |
If length is => 1 and =< 4000, then: NVARCHAR (Length in Bytes) If length is => 4001 and =< 2147483647, then: NVARCHAR (4000) |
|
BLOB |
Full Load: VARBINARY (8000) Change Processing: VARBINARY (4000) |
|
NCLOB |
NVARCHAR (4000) |
|
CLOB |
Full Load: VARCHAR (8000) Change Processing: VARCHAR (4000) |
Full LOB data types are not supported. For information on including Limited-size LOB data types in the replication, see the Metadata tab description in Customizing tasks .