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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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