Setup bi directional tasks

[Finnova]

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.

[Gerald_U]

Hello,

Please review the user guide on bi-directional replication:

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedEMReplicate/D...

Regards,

Gerald 

[Finnova]

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

[shashi_holla]

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,