MySql To Sql Server

[ZuhaibRana]

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

[Steve_Nguyen · Accepted solution]

@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...

[lyka · Accepted solution]

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.

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

Thanks

Lyka

[ZuhaibRana]

Thanks. Problem Solved