topic Re: Mysql endpoint session variable in Qlik Replicate

Mysql endpoint session variable

dade73 — Wed, 26 Jul 2023 08:41:28 GMT

Hi,

is it possible to add/set session variables in a Mysql enpoint connector?

thank you in advance

cheers

davide

Re: Mysql endpoint session variable

john_wang — Wed, 26 Jul 2023 08:51:39 GMT

Hello @dade73 ,

Thanks for reaching out to Qlik Community!

There are different SET SESSION clauses in MySQL. May we know what's the exact purpose of it? or are you struggling with some errors? A sample is much helpful to understand the request.

Regards,

John.

Re: Mysql endpoint session variable

dade73 — Wed, 26 Jul 2023 08:58:49 GMT

Hello @john_wang ,

I need to set a user defined variable for the replicate session, to disable some trigger while importing data.

set @TRIGGER_CHECKS=false;

thank you!

Regards

Davide

Re: Mysql endpoint session variable

john_wang — Wed, 26 Jul 2023 09:29:40 GMT

Hello Davide @dade73 ,

Thanks for the update.

Are you able to confirm it's MySQL source endpoint, or MySQL target endpoint?

What's the MySQL Version and Replicate version please.

Regards,

John.

Re: Mysql endpoint session variable

dade73 — Wed, 26 Jul 2023 10:03:54 GMT

Hello

is on target endpoint. Im loading on mariadb so i would say mysql 5.7.

Thank you

Regards

Davide

Re: Mysql endpoint session variable

john_wang — Wed, 26 Jul 2023 10:31:27 GMT

Hello @dade73 ,

Thanks for the clarification.

Let's try this way:

1. Open MySQL target endpoint

2. Goto Advanced tab

3. Press "internal parameter"

4. Add an internal parameter, name "additionalConnectionProperties" and set its value to

initstmt=set @TRIGGER_CHECKS=false;

The screenshot of a sample:

Save the setting and re-run the task again. Let me know if it works for you.

Regards,

John.

Re: Mysql endpoint session variable

dade73 — Thu, 27 Jul 2023 13:31:58 GMT

hi @john_wang

is working, but sadly in the trigger do not get seen.

I had to find another way.

thank you

regards

Davide