Skip to main content Skip to complementary content

Supported data types

The following table shows the source data types that are supported when using Qlik Replicate and the default mapping to Qlik Replicate data types. Note that source 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.

Information note

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

Supported data types
Microsoft SQL Server (MS-CDC) 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

Information note
  • LOB columns for Microsoft SQL Server (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server (MS-CDC).
  • To use this data type with Qlik Replicate, you must enable the use of CLOBs 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

*NCHAR

WSTRING

*NVARCHAR (length)

WSTRING

*NVARCHAR (max)

*NTEXT

Information note
  • LOB columns for Microsoft SQL Server (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server (MS-CDC).
  • 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.

NCLOB

BINARY

BYTES

VARBINARY

BYTES

VARBINARY (max)

IMAGE

Information note
  • LOB columns for Microsoft SQL Server (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server (MS-CDC).
  • 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

Information note
  • LOB columns for Microsoft SQL Server (MS-CDC) tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server (MS-CDC).
  • 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

Non-supported data types

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

  • CURSOR
  • SQL_VARIANT
  • TABLE
Information note

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!