Amazon RDS for SQL server source data types
Last updated: 9/9/2026The Amazon RDS for SQL Server source for Qlik Replicate supports most Amazon RDS for SQL Server data types. The following table shows the Amazon RDS for SQL Server source data types that are supported when using Qlik Replicate and the default mapping to Qlik Replicate data types. Note that Amazon RDS for SQL Server data types are only mapped to Qlik Replicate data types when the target endpoint is not Amazon RDS for SQL Server. For information on data type mapping and collation support when the target endpoint is Amazon RDS for SQL Server, 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 (*).
| Amazon RDS for SQL server data types | Qlik Replicatedata 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 Amazon RDS for SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Amazon RDS for SQL Server. During CDC, CLOB data types are supported only in tables that include a primary key. For more information, see LOB support in Task Settings/Metadata. |
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 Amazon RDS for SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Amazon RDS for SQL Server. During CDC, NCLOB data types are supported only in tables that include a primary key. For more information, see LOB support in Task Settings/Metadata. |
NCLOB |
|
BINARY |
BYTES |
|
VARBINARY |
BYTES |
|
VARBINARY (max) IMAGE LOB columns for Amazon RDS for SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Amazon RDS for SQL Server. To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task. BLOB data types are supported only in tables that include a primary key. For more information, see LOB support in Task Settings/Metadata. |
BLOB |
|
TIMESTAMP |
BYTES |
|
UNIQUEIDENTIFIER |
STRING |
|
HIERARCHYID |
STRING (250) |
|
XML LOB columns for Amazon RDS for SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Amazon RDS for SQL Server. To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task. During CDC, NCLOB data types are supported only in tables that include a primary key. For more information, see LOB support in Task Settings/Metadata. |
CLOB |
|
GEOMETRY |
NCLOB |
|
GEOGRAPHY |
NCLOB |
| JSON | NCLOB with JSON subtype |
Non-supported data types
Tables that include fields 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.