Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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