Microsoft Azure SQL Managed Instance source data types
The Microsoft Azure SQL Managed Instance source for Qlik Replicate supports most Microsoft Azure SQL Managed Instance data types. The following table shows the Microsoft Azure SQL Managed Instance source data types that are supported when using Qlik Replicate and the default mapping to Qlik Replicate data types. Note that Microsoft Azure SQL Managed Instance data types are only mapped to Qlik Replicate data types when the target endpoint is not Microsoft Azure SQL Managed Instance. For information on data type mapping and collation support when the target endpoint is Microsoft Azure SQL Managed Instance, see Homogeneous replication .
For information on how to view the data type that is mapped in the target, see the section for the target endpoint you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
When row size exceeds 8060, the VARCHAR, NVARCHAR, and VARBINARY data types will be stored out-of-row. To replicate such data, use the source lookup function described in Data Enrichment.
Collatable data types are indicated by an asterisk (*).
| Microsoft Azure SQL Managed Instance Data Types | Qlik Replicate Data Types |
|---|---|
|
BIGINT |
INT8 |
|
BIT |
BOOLEAN |
|
DECIMAL |
NUMERIC |
|
INT |
INT4 |
|
MONEY |
NUMERIC (19,4) |
|
NUMERIC (p,s) |
NUMERIC |
|
SMALLINT |
INT2 |
|
SMALLMONEY |
NUMERIC (10,4) |
|
TINYINT |
UINT1 |
|
REAL |
REAL4 |
|
FLOAT |
REAL8 |
|
DOUBLE |
REAL8 |
|
DATETIME |
DATETIME |
|
DATETIME2 |
DATETIME |
|
SMALLDATETIME |
DATETIME |
|
DATE |
DATE |
|
TIME |
STRING (16) |
|
DATETIMEOFFSET |
STRING |
|
*CHAR |
STRING |
|
*VARCHAR |
STRING |
|
*VARCHAR (max) *TEXT To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task. LOB columns for Microsoft Azure SQL Managed Instance tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL Managed Instance. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
CLOB |
|
*NCHAR |
WSTRING |
|
*NVARCHAR (length) |
WSTRING |
|
*NVARCHAR (max) *NTEXT To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task. LOB columns for Microsoft Azure SQL Managed Instance tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL Managed Instance. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
NCLOB |
|
BINARY |
BYTES |
|
VARBINARY |
BYTES |
|
VARBINARY (max) IMAGE LOB columns for Microsoft Azure SQL Managed Instance tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL Managed Instance. To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
BLOB |
|
TIMESTAMP |
BYTES |
|
UNIQUEIDENTIFIER |
STRING |
|
HIERARCHYID |
VARCHAR (x) |
|
XML LOB columns for Microsoft Azure SQL Managed Instance tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL Managed Instance. To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
CLOB |
|
GEOMETRY |
CLOB |
|
GEOGRAPHY |
CLOB |