Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
ZuhaibRana
Partner - Contributor III

MySql To Sql Server

I using MySql as a source and Sql Server as a target in qlik replicate when i run the task i got following error.

Stream component 'st_0_Mysql to sql source' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_Mysql to sql source'.
Errors in MySQL server validation.
Binary logging is disabled for MySQL server

 

Labels (1)
2 Solutions

Accepted Solutions
Steve_Nguyen
Support

@ZuhaibRana

you need to enable binary logging, this is one of the requirement:

 

Enable binary logging

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedReplicateHDD/MySQL...

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

View solution in original post

lyka
Support

Hello,

To enable binary logging (required for CDC replication), the following parameters must be configured in MySQL’s my.ini (Windows) or my.cnf (UNIX) files.

lyka_0-1654610911903.png

Source: https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedReplicateHDD/MySQL...m

Thanks

Lyka

View solution in original post

3 Replies
Steve_Nguyen
Support

@ZuhaibRana

you need to enable binary logging, this is one of the requirement:

 

Enable binary logging

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedReplicateHDD/MySQL...

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
lyka
Support

Hello,

To enable binary logging (required for CDC replication), the following parameters must be configured in MySQL’s my.ini (Windows) or my.cnf (UNIX) files.

lyka_0-1654610911903.png

Source: https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedReplicateHDD/MySQL...m

Thanks

Lyka

ZuhaibRana
Partner - Contributor III
Author

Thanks. Problem Solved