Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Connect Strings - SQL Server

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

1 Solution

Accepted Solutions
flipside
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

2 Replies
flipside
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

Hi Mate,

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

Thank so much for your response

Cheers,

Byron