topic Re: Replication of MS SQL Server table with Columnstore Index in Qlik Replicate

Replication of MS SQL Server table with Columnstore Index

jmiao — Tue, 29 Nov 2022 21:53:22 GMT

Hi,

This is noted within the limitations of Qlik but is there a workaround for this issue?

Thanks,

Jian

Re: Replication of MS SQL Server table with Columnstore Index

lyka — Tue, 29 Nov 2022 22:02:49 GMT

Hi Jian,

If this is a required use case, you can try using the ODBC with CDC endpoint as a workaround. However, as noted in the user guide, this needs to be communicated to your QDI Specialist and implemented thru Professional Services.

For your reference:

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/ODBC%20with%20CDC/odbc_source_with_CDC.htm

Hope this helps!

Thanks

Lyka

Re: Replication of MS SQL Server table with Columnstore Index

john_wang — Wed, 30 Nov 2022 10:27:17 GMT

Hello @jmiao ,

Replicate provides 2 drivers to capture Microsoft SQL Server source DB changes. One way is reading changes from TLOG, another approach is using MS-CDC. However both of the drivers cannot get changes from table with Columnstore Index, this is because of Microsoft SQL Server itself limitation rather than Replicate limitation. Here is the MS docs reference page Columnstore indexes can't be combined with the following features .

Totally agree with @lyka , I think this is the one option (without change the table structure eg add PK etc). Or uses VIEW or table to do repeat Full Load ONLY replication.

Regards,

John.