Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Howto define odbc connection properties in Qlik Sense

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;

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand