Qlik Replicate: Microsoft SQL Server 2025 release and native JSON datatype support

john_wang — Thu, 04 Dec 2025 14:09:02 GMT

Previous versions of Microsoft SQL Server do not support a dedicated JSON data type.

For later versions, Microsoft announced the introduction of a native JSON data type (along with JSON aggregate functions). This new data type is already available in Azure SQL Database and Azure SQL Managed Instance, and is included in SQL Server 2025 (17.x).

SQL Server 2025 (17.x) became Generally Available (GA) on November 18, 2025.

At this time, the current Qlik Replicate major releases 2025.05/2025.11 do not support SQL Server 2025 or its native JSON data type yet.

Environment

Qlik Replicate all versions
SQL Server 2025 on-premises
Azure SQL Database and Azure SQL Managed Instance (which share the same engine as SQL Server 2025)

Common Errors Observed if the table contains a JSON column in SQL Server 2025

SQL Server endpoint with SQL Server 2025 as the source

During the endpoint connection ping test, you may encounter:

SYS-E-HTTPFAIL, Unsupported server/database version: 0.
SYS,GENERAL_EXCEPTION,Unsupported server/database version: 0

MS-CDC endpoint with Azure SQL Database as the source

Since the Azure SQL Database version is always 14.x, the version check succeeds. However, Azure SQL DB already uses the SQL Server 2025 kernel, the task later fails during runtime with:

[SOURCE_CAPTURE ]T: Failed to set ct table column ids for ct table with id '1021246693' (sqlserver_mscdc.c:2968)
[SOURCE_CAPTURE ]T: Failed to get change tables IDs for capture list [1000100] (sqlserver_mscdc.c:3672)
[SOURCE_CAPTURE ]E: Failed to get change tables IDs for capture list [1000100] (sqlserver_mscdc.c:3672)

Resolution

No workaround can be provided until support has been introduced.

According to the current roadmap, support for SQL Server 2025 and the native JSON data type is planned for the upcoming major release: Qlik Replicate 2026.5.

No date or guaranteed timeframe can yet be given. The support planned for 2026.5 is an estimate.

Internal Investigation ID(s)

00419519

Re: Qlik Replicate: Microsoft SQL Server 2025 release and native JSON datatype support

john_wang — Fri, 03 Apr 2026 13:04:41 GMT

Important update:

SQL Server 2025 as a source endpoint has been supported since Replicate 2025.11 SP3 (released on April 1, 2026).

Jira issue : RECOB-10895
Salesforce case : N/A
Type : Enhancement

Component/Process: Microsoft SQL Server Source
Description : Certified Microsoft SQL Server 2025.

However, support for the native JSON data type is currently planned for the Replicate 2026.5 release. I will keep the article updated if there are any changes or earlier availability.

article Qlik Replicate: Microsoft SQL Server 2025 release and native JSON datatype support in Official Support Articles