topic Re: using two different connection strings in QlikView

using two different connection strings

Mon, 18 Nov 2013 06:26:55 GMT

Hi,

I am new to qlikview,I need to know how i could connect to 2 different servers like server for testing and the server for development in my qlikview application.Can anyone please let me know about how this could be done with a descriptive explaination

Re: using two different connection strings

sivarajs — Mon, 18 Nov 2013 09:45:25 GMT

If two connection strings has given simultaneously,only the last string will establish the connection. So you may the following approach.

In load script,

Connecting string 1

Load * from table //load the data

Connecting string 2

Load * from table //load the data

Re: using two different connection strings

israrkhan — Mon, 18 Nov 2013 09:56:21 GMT

Yes, You can create two connections.

just create your connection strings for on both servers.

and then in the script, you can load data from both data bases, or you can make a condition.

in the below script, will check if connection1 is not established then read from second, else from first

set script error =0;

Connecting1

if scripterror = 0

then

Load * from table //load the data

else

Connecting string 2

Load * from table //load the data