Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies