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
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.
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.
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
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.
