Replicate to mariadb with foreign key

[gaegig]

Hello everybody,

we are trying to move data from Oracle to mariadb.

On target all tables are created already with all foreign key (high normalized database). We can't stop service and the switch of connection from oracle to maria  must be the shortest possible.

In mariadb we can set a session variable (foreign_key_checks=0) to avoid the control of foreign key, but this parameter could be set on session level (we can't set as global because on target cluster we have other databases running)

There is a way to set the target parameter foreign_key_checks=0 on qlik's replicate job?

Thank you in advnace for your help.

[john_wang · Accepted solution]

Hello @gaegig ,

Can you have a try in lower env to see if it works:

1. Open the MariaDB endpoint and add an internal parameter "additionalConnectionProperties". set its value to

initstmt=SET FOREIGN_KEY_CHECKS=0;

2.  Stop and Resume the task

Hope it helps.

Regards,

John.

[gaegig]

John thats great, it works perfectly after setting the parameter. Thank you very much for your support!

[john_wang]

Hello @gaegig ,

Glad to hear that 😄, thanks for your update.

BTW, please press the "Accept as Solution" if you confirm it works for you. it's helpful for others.

thank you,

John.