topic Re: Multiple Connect Strings - SQL Server in QlikView

Multiple Connect Strings - SQL Server

Fri, 26 Apr 2013 11:05:48 GMT

Hi All,

Is it possible to connect to two different servers within the same SQL select statement

The script reads something like this

$(Include=$(vConnectionFilePath));

SQL Select a, b, c

FROM server.dbo.tablename i

LEFT JOIN server2.dbo.tablename j ON i.a = j.a and i.b = j.b

Essentially how can you tell qlikview to change the connection string or include a different connection string within the a left join of a sql select statement

Your help is much appreciated

Cheers,

Byron

Re: Multiple Connect Strings - SQL Server

flipside — Fri, 26 Apr 2013 11:18:22 GMT

Hi Byron,

Not as far as I know.

You could have server2 as a linked server on server1 (or vice-versa) SQL server side to allow cross-server queries OR make two separate connections in Qlikview and make the join in Qlikview.

flipside

Re: Multiple Connect Strings - SQL Server

Fri, 26 Apr 2013 11:26:23 GMT

Hi Mate,

I was being an idiot Yes the linked server worked like a charm

Thank so much for your response

Cheers,

Byron