Microsoft SQL Server source data types
The Microsoft SQL Server source for Qlik Replicate supports most Microsoft SQL Server data types. The following table shows the Microsoft SQL Server source data types that are supported when using Qlik Replicate and the default mapping to Qlik Replicate data types. Note that Microsoft SQL Server data types are only mapped to Qlik Replicate data types when the target endpoint is not Microsoft SQL Server. For information on data type mapping and collation support when the target endpoint is Microsoft SQL Server, see Homogeneous replication below.
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 SQL Server 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 SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server. 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 SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server. 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 SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server. 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 SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Microsoft SQL Server. 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 |
Unsupported data types
The following data types are not supported:
- 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.