Prerequisites - Qlik Replicate

[vinodg]

Hi,

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

[Heinvandenheuvel]

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 · Accepted solution]

Hi @vinodg 

Thanks for your questions !

1. Can you please confirm where CDC needs to be enabled on the source system to use qlik?  >>  YES
2. To read transaction logs what kind of permission need to be granted?     >>>>     Depends on the source
3. 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:  

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/source%20endpoints/Add_manage_s...

Sincerely,

Barb