topic Re: MySql To Sql Server in Qlik Replicate

MySql To Sql Server

ZuhaibRana — Mon, 06 Jun 2022 11:59:22 GMT

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

Re: MySql To Sql Server

Steve_Nguyen — Mon, 06 Jun 2022 12:11:36 GMT

@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-Source/prereq-mysql-source.htm

Re: MySql To Sql Server

lyka — Tue, 07 Jun 2022 14:08:57 GMT

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-Source/prereq-mysql-source.htm

Thanks

Lyka

Re: MySql To Sql Server

ZuhaibRana — Thu, 09 Jun 2022 05:38:17 GMT

Thanks. Problem Solved