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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
PC-1
Contributor II
Contributor II

Is it possible to replicate to two different endpoints without using Log Stream ?

Is it possible to use Qlik Replicate with an MSSQL source endpoint to replicate to two different end points without using Log Stream and still maintain transactional consistency ?

 

For example assuming the

Source endpoint is an MSSQL database

Target endpoints are Sybase ASE database and Azure SQL database

 

Labels (1)
1 Solution

Accepted Solutions
john_wang
Support
Support

Hello @PC-1 ,

Yes, you can configure two separate tasks. However, this will double the load on the source endpoint, since the same change data must be read and parsed twice. This is exactly where Log Stream adds value—it reads the changes once and then distributes them to multiple target endpoints.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

1 Reply
john_wang
Support
Support

Hello @PC-1 ,

Yes, you can configure two separate tasks. However, this will double the load on the source endpoint, since the same change data must be read and parsed twice. This is exactly where Log Stream adds value—it reads the changes once and then distributes them to multiple target endpoints.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!