1 Reply Latest reply: Aug 28, 2015 12:59 PM by Gysbert Wassenaar RSS

    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;