Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more

How does Qlik Replicate define the publication name in SQL server sources?

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
SwathiPulagam
Support
Support

How does Qlik Replicate define the publication name in SQL server sources?

Last Update:

May 30, 2022 6:22:49 AM

Updated By:

Sonja_Bauernfeind

Created date:

May 30, 2022 6:21:41 AM

By default, Qlik Replicate tries to use Microsoft SQL Server native replication feature to support capture changes from the SQL Server source.

When we start the Qlik Replication task with SQL Server as a source, Qlik Replicate will verify that the MS Replication feature is enabled or not, and once all the pre-requisites are met Qlik replicate will try to create the publication with the name AR_PUBLICATION_XXXX where XXXX represents the dbid of the Replicated database as shown in the below picture.

SwathiPulagam_1-1653704658622.png

 

Note: Each time when we stop and resume the task, Qlik Replicate will verify whether the publication exists with the name AR_PUBLICATION_XXXX and if the publication does not exist then Qlik Replicate will automatically create the publication with the name AR_PUBLICATION_<dbid>.

 

Environment

Qlik Replicate 
#SQL Server source

 

Labels (1)
Version history
Last update:
‎2022-05-30 06:22 AM
Updated by: