How do I use variables in an ODBC connection string, in Sense?
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.