topic How do I use variables in an ODBC connection string, in Sense? in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/How-do-I-use-variables-in-an-ODBC-connection-string-in-Sense/m-p/1380209#M2988 <HTML><HEAD></HEAD><BODY><P>Basically I need to do this in Qlik Sense:</P><P></P><P>ODBC CONNECT TO $(vDW_ODBC) (XUserId is $(vDWUser), XPassword is&nbsp; $(vDWPassword));</P><P></P><P>I've looked around for a long time but I cannot see how it's done. Can you help me?</P><P><SPAN style="font-size: 10pt;">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.</SPAN></P></BODY></HTML> Wed, 20 Sep 2017 11:36:54 GMT stagu_ist 2017-09-20T11:36:54Z How do I use variables in an ODBC connection string, in Sense? https://community.qlik.com/t5/Connectivity-Data-Prep/How-do-I-use-variables-in-an-ODBC-connection-string-in-Sense/m-p/1380209#M2988 <HTML><HEAD></HEAD><BODY><P>Basically I need to do this in Qlik Sense:</P><P></P><P>ODBC CONNECT TO $(vDW_ODBC) (XUserId is $(vDWUser), XPassword is&nbsp; $(vDWPassword));</P><P></P><P>I've looked around for a long time but I cannot see how it's done. Can you help me?</P><P><SPAN style="font-size: 10pt;">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.</SPAN></P></BODY></HTML> Wed, 20 Sep 2017 11:36:54 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-do-I-use-variables-in-an-ODBC-connection-string-in-Sense/m-p/1380209#M2988 stagu_ist 2017-09-20T11:36:54Z