Supported data types

The Microsoft Azure SQL (MS-CDC) source endpoint 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 SQL Server-based. For information on data type mapping and collation support when the target endpoint is Microsoft SQL Server-based, 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.

Collatable data types are indicated by an asterisk (*).

Supported data types
Microsoft Azure SQL Managed Instance	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 (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL (MS-CDC).	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 (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL (MS-CDC).	NCLOB
BINARY	BYTES
VARBINARY	BYTES
VARBINARY (max) IMAGE LOB columns for Microsoft Azure SQL (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL (MS-CDC). To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task.	BLOB
TIMESTAMP	BYTES
UNIQUEIDENTIFIER	STRING
HIERARCHYID	VARCHAR (x)
XML LOB columns for Microsoft Azure SQL (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft Azure SQL (MS-CDC). To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task.	CLOB
GEOMETRY	CLOB
GEOGRAPHY	CLOB

Non-supported data types

Tables that include columns with the following data types are not supported by Qlik Replicate.

CURSOR
SQL_VARIANT
TABLE

User-defined data types are supported according to their base-type. For example, a user-defined data type based on DATETIME is handled as a DATETIME data type.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here