topic Setup bi directional tasks in Qlik Replicate

Setup bi directional tasks

Finnova — Thu, 02 Mar 2023 15:16:56 GMT

Hello Qlik support,

What is the best practice to set up a bi-directional task (oracle<>ms sql server)? What are the settings that are required on the ms sql server? Does the recovery model on the database where the table that needs to be replicated bi directionaly need to be on full or bulk logged or are there possibilities running the db on simple (as the db has many tables and setting it to full or bulk logged is not really an option)

Thanks for your help.

Re: Setup bi directional tasks

Gerald_U — Thu, 02 Mar 2023 15:19:15 GMT

Hello,

Please review the user guide on bi-directional replication:

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedEMReplicate/Design%20Tasks/Set_up_Bidirectional_Replication.htm#Setting%20up%20Bidirectional%20replication

Regards,

Gerald

Re: Setup bi directional tasks

Finnova — Thu, 02 Mar 2023 15:29:13 GMT

Hi Gerald,

I had already read the provided description. After this I had opened this ticket.

Could you please analyze if there is a solution for our problem or not. Are there any best practices?

Thanks for your help.

Regards,

Marc

Re: Setup bi directional tasks

shashi_holla — Thu, 02 Mar 2023 16:49:45 GMT

Hi @Finnova

All the limitations applicable to the Unidirectional task when using SQL Server apply to Bidirectional as well. In other words, if the endpoint is currently working with a unidirectional task, it will work for Bidirectional.

Bidirectional is basically a 2 unidirectional task setup to work in tandem. Hence, we have to ensure both the tasks should have the same loopback schema defined in the task settings.

Also following additional limitations apply:

The Use direct path full load option in the Oracle target endpoint settings is not supported.
The task's Change Processing Mode must be set to Transactional apply.

Thank you,