Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community ,
in server migration time if change the connection string then its a process whcih we have to do manual and we have to open qvw to connect the string with new server .
for this solution if there any other approach which can save this time like we can save connection string in variable or we can fatch connection string from particulate location ??
plz suggest best approach to do this activity because my server has migrated and i'm changing connection string in all the application manually gwassenaarmavarrudagwassenaar
I don't think so there is any other way (I may be wrong), because you need to create the DSN on new server and then you can use QlikView to use that DSN to connect to your database. So Need to manually change the connection string
Hi
Create a config file and add this as include statement in the qvw.
In config file create a variable and store the connection string in it.
Everytime you move the file to server , you can change connection string in the config file without opening main file to be deployed.
That is correct. To be super-precise:
You need to create txt file with proper connection string (as part of script). In each of your QV documents you need to place include statement before main load script for example:
$(Must_Include=..\Include\ConnectionString.txt);
In the future that will provide you changing data source parameters only in one place - not in each document every time.
You can read/watch about Include, Must_Include statements from links below or just search the Community for it.
Hi,
Are you using ODBC / DSN Name for Connection. if yes, then you can just copy the ODBC registry info of your old server and merge that in the new server. You can take help of Wintel Team.
Ankit has provided a way.
There are number of ways to do it:
You can have the tect file and write all connection and then call and assign each to a variable or you can have a connection string with default entries and just update the workstation and DB
If your are using ODBC, I think there is no way you have to connect to the DSN once it is changed but if it is OLEDB
you can use a simple Excel file
like
Variable ConnectionString
Dev ...
Prod ....
Test ...
Load this file into edit script using $ include
and just change the variable
Like
$(Dev)
We are using a kind of it in ours using qvc components.
'
You can store the connection strings in an external script file and include that script file in your qlikview documents using the Include directive. See this blog post: The $(Include) which you $(Must_Include) into your toolkit. Of course it does mean that you need to manually change every Qlikview workbook once to make use of this feature.