topic Re: Configuration CDC extraction (MS REPLICATION or MS CDC) in Qlik Replicate

Configuration CDC extraction (MS REPLICATION or MS CDC)

jorgetrillo — Wed, 09 Nov 2022 10:55:27 GMT

Hello,

I have a question about how configure CDC extraction task.

I know there are two types:
- MS REPLICATION: directly conected to the "Transaction Log".
- MS CDC: directly connected to "Change Tables".

1) I want to configure a task as "MS REPLICATION", but also I want to know how can I change from one configuration to the other one.

2) When I am configuring the task in "Manage Endpoint Connections", inside "Internal Parameters" sometimes I can see some parameters and other times I cannot see any paramenter.
--> My question is Why is this happening?

I attached a screenshot with the two scenarios. Why sometimes I can see parameters and other times not.

Thank you very much in advance.

Kind regards,
Jorge.

Re: Configuration CDC extraction (MS REPLICATION or MS CDC)

SwathiPulagam — Wed, 09 Nov 2022 13:03:59 GMT

Hi @jorgetrillo ,

For your 1st question, you have to work with your DBA in granting the required privileges and enable MS-CDC as per the user guide.

The below article explains more Techincal information about MS Replication and MS CDC:

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-MS-REPLICATION-vs-MS-CDC/ta-p/1939350

If you need a hands-on session then please reach out to our Professional Services Team.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Technical-Support-and-Professional-Services-When-to-reach/ta-p/1945947

Thanks,

Swathi

Re: Configuration CDC extraction (MS REPLICATION or MS CDC)

SwathiPulagam — Wed, 09 Nov 2022 13:07:26 GMT

Hi @jorgetrillo ,

For your 2nd question:

Internal parameters are individual to the endpoint. If you add and save the endpoint then it will show in that specific endpoint. If you need more explanation you can create a case, we can schedule a call and explain about the internal parameters.

Thanks,

Swathi