Howto define odbc connection properties in Qlik Sense

[#1]

In Qlik Sense I can define an odbc connection and connect to my mysql database with;

LIB CONNECT TO [myconnection];

But what I really want to do is something like this (pseudo code)

// Define variables:

LET vUser = 'myuser';

LET vPassword = 'mypass';

LET vHost = 'localhost';

LET vPort = 3306;

LET vSchema = 'mydb';

LIB CONNECT TO ODBC with "DRIVER={MySQL ODBC 5.3 Unicode Driver};UID=" & vUser & ";PWD=" & vPassword & ";SERVER=" & vHost & ";PORT=" & vPort & ";DATABASE=" & vSchema;

[Gysbert_Wassenaar]

As far as I know the only way to achieve that is to enable the Legacy mode. See this blog post: Qlik Sense Legacy mode