Replication of MS SQL Server table with Columnstore Index

[jmiao]

Hi,

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

Thanks,

Jian

[lyka · Accepted solution]

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_sou...

Hope this helps!

Thanks

Lyka

[john_wang]

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.