Mysql endpoint session variable

[dade73]

Hi,

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

thank you in advance

cheers

davide

[john_wang]

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.

[dade73]

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

[john_wang]

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.

[dade73]

Hello 

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

Thank you

Regards

Davide

[john_wang]

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.

[dade73]

hi @john_wang 

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

I had to find another way.

thank you

regards

Davide