topic Re: Changing the ODBC Connection From Dev to Prod in QlikView

Changing the ODBC Connection From Dev to Prod

Tue, 04 Feb 2014 15:44:25 GMT

Hi All,

I'm new to Qlikview.How can i change the source ODBC Connection from Dev to Prod.I dont want to do it manually all the time in all QVW's.Is there any way to do it ?

Re: Changing the ODBC Connection From Dev to Prod

dcheung3388 — Tue, 04 Feb 2014 15:53:37 GMT

Hi,

I would suggest that you put your connection string inside a dbconnection string text file, then within your QVW load script like below..

// Connection String text file.

$(Include=..\[path name]\dbconnect45.txt);

Then all you need to do is use the same file for dev and production, but on your production machine, have the production connection string.

Hope this helps.

David

Re: Changing the ODBC Connection From Dev to Prod

sudeepkm — Tue, 04 Feb 2014 16:19:37 GMT

Assume that you have the same folder structure on your DEV and PROD environment but on two different machines with different host names.

You can create a variable in Script such as

let vpath=GetFolderPath('..\Application');

let vEnv = if('$(vpath)'='prod.domain.com','PROD','DEV');

now based on the value of vEnv you can use the connection string for respective environment.