In Qlikview is it posible to change the Datasource of a QVW from one to another

[#1]

Hello to everybody,

I am new to qlikview, i want some knowledge on this.
My query is ,if somebody has created a QVW with the help of one Server let's say Server1 (Datasource) and then after developing the QVW
he/she wants to change the datasource of the same QVW to another lets say (Server2). Whether is it posible ?
if yes then how it would be done and how feasible it would be.

Please share some valuable points, so that it will be helpful.
Thank you so much in advance.

ssd

[suniljain]

you can use disconnect for close one connection and access another connection or open another connection.

so you can use extract data from multiple data source in single application.

[gandalfgray]

Hi

Yes it's possible.

One alternative is to manually change the connect string(s) when you want to "go live".

You could keep both in the script and comment one out depending on which one you want to use.

hth/gg

[#4]

Hi,

Thanks for replying.

You mean in the same QVW edit sript we need to change the ODBC Connect statement? But i guess for that we need to have same datasource table structure. Am i correct. Please reply.

[suniljain]

Following scenario do not require same table structure. pls check following logic.

Connection 1

select * from sources of connection 1;

disconnect

Connection 2

Sellect * from sources of connection 2

disconnect.

[its_anandrjs]

Hi,

No you need to just use the flags, For this you can use the Flags variables to open or close the connection and use the tables from there.

Just select datasource by flag so at a time you have a connection to load data.

Regards

Anand

[#7]

Sunil , what i mean to say,

lets say i have created a qvw

ODBC connect server1.....

and later on i need to replace the above qvw with the

ODBC connect server2.....

So in that case the whatever table structure have been used in Server1 that need not to be same in Server2?????

[chriscammers]

If you are talking about changing between dev and production data I reccommend using an "include" file with the connection string in it. then when you want to change the database you only  have to change the include file.