Qlik Replicate tasks for reading data from SQL Server, both with replication enabled and without replication.

[Rak]

Is there comprehensive documentation available on using Qlik Replicate to extract data from SQL Server objects, including approaches with replication, CDC, and without either replication or CDC?

I’m looking for detailed information on each approach, including the pros and cons. I understand that the choice depends on the specific use case, but Looking for a list with all possible methods and clearly outline the use case for each, along with their advantages and disadvantages.

Limitations with SQL Server objects with each of these approaches.

[narendersarva]

Hi @Rak 

Please refer user guide 

Using Microsoft SQL Server as a source | Qlik Replicate Help

[DesmondWOO]

Hi @Rak ,

Choosing between MS-Replication and MS-CDC primarily depends on whether your tables have a primary key. MS-Replication requires source tables to have a primary key, as mandated by SQL Server. Please refer to the user guide linked below:

Replicating tables that do not have a primary key

I also recommend comparing the limitations and considerations of the following endpoints:

• Using Microsoft SQL Server as a source
• Using Microsoft SQL Server (MS-CDC) as a source

Regards,
Desmond

[sureshkumar]

Hello @Rak 

Kindly refer the below article:

Qlik Replicate: MS_REPLICATION vs MS-CDC - Qlik Community - 1939350

Regards,

Suresh