topic Re: Prerequisites - Qlik Replicate in Qlik Replicate

Prerequisites - Qlik Replicate

vinodg — Fri, 13 May 2022 12:37:30 GMT

Hi,

Can you please confirm where CDC need to be enabled on source system to use qlik?
To read transaction logs what kind of permission need to be granted?
For initial load from source DB system do you need a sql user to be created on source system?

Heinvandenheuvel — Fri, 13 May 2022 12:43:08 GMT

RTFM, Read the user guide.

Read it again.

Chapter 8 - Adding and managing source endpoints

Most likely

8.15 Using Microsoft SQL Server as a source : Prerequisites

1 - no - need (local) distributor, and articles

2 - Need the keys to the kingdom for archived logs. sysadm

3 - yes - duh! How else?

Hein.

Barb_Fill21 — Fri, 17 Jun 2022 22:48:41 GMT

Thanks for your questions !

Can you please confirm where CDC needs to be enabled on the source system to use qlik? >> YES
To read transaction logs what kind of permission need to be granted? >>>> Depends on the source
For the initial load from the source DB system do you need a SQL user to be created on the source system? >> Yes.

Definitely see the User Guide for the source endpoint you are using. 🙂

See this link:

Sincerely,

Barb