0 Replies Latest reply: Sep 20, 2017 7:36 AM by Staffan Gustafsson RSS

    How do I use variables in an ODBC connection string, in Sense?

    Staffan Gustafsson

      Basically I need to do this in Qlik Sense:

       

      ODBC CONNECT TO $(vDW_ODBC) (XUserId is $(vDWUser), XPassword is  $(vDWPassword));

       

      I've looked around for a long time but I cannot see how it's done. Can you help me?

      The reason for it is a need to use around 150 different DW addresses, users and passwords for 150 different customers (but with similar DW structure) and these need to be loaded from a .qvs file for ease of access and maintenance.