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

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

Rak — Thu, 19 Sep 2024 16:33:03 GMT

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.

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

narendersarva — Thu, 19 Sep 2024 17:39:32 GMT

Hi @Rak

Please refer user guide

Using Microsoft SQL Server as a source | Qlik Replicate Help

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

DesmondWOO — Fri, 20 Sep 2024 02:25:48 GMT

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:

Regards,
Desmond

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

sureshkumar — Sat, 21 Sep 2024 18:59:07 GMT

Hello @Rak

Kindly refer the below article:

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

Regards,

Suresh