topic Re: Connect multiple databases sql in QlikView

Connect multiple databases sql

Sa20 — Mon, 26 Jan 2026 21:26:37 GMT

Please how can i connect multiple databases sql to analyze it as a single database in qlikView ?

Re: Connect multiple databases sql

shiveshsingh — Sun, 05 May 2019 10:16:35 GMT

You can create multiple connection strings and import data in qlikview.

After that, you can create single model as per your requirement.

Re: Connect multiple databases sql

rubenmarin — Sun, 05 May 2019 10:16:57 GMT

Hi, you can store connection string in txt, and use a for each bucle to connect to each one to retrieve data, ie, assuming that all databases have the same tables:
for each table in 'table1','table2','table3' //fill with table names
for each connection in 'Connection1','Connection2','Connection3' //fill with txt names of connection strings
$(Include=path_to_connections\$(connection).txt); //this loads the connection
// Retrieve data from all connections
[$(table)]:
LOAD '$(connection)' as connection,
*
from [$(table)];
next
// store joined data into a qvd, this qvd will be readed by the app to load the data
Store [$(table)] into [Path_to _qvds_folder\$(table).qvd];
Drop [$(table)];
next

Re: Connect multiple databases sql

jonathandienst — Sun, 05 May 2019 15:48:47 GMT

Follow this pattern:

Connection for first database
Load whatever data required from first database
Open connection for next database (this will implicitly disconnect the first)
Load whatever data required from second database (and concatenate or join to the earlier tables as required)
Open connection to third database
Etc Etc

The data from all the sources will be loaded into a single QVW file for analysis.

Re: Connect multiple databases sql

Sa20 — Tue, 07 May 2019 13:32:39 GMT

But databases do not have the same tables

Re: Connect multiple databases sql

rubenmarin — Tue, 07 May 2019 13:50:38 GMT

You can create different variables to store table names:
SET vTablesConnection1 = 'Table1_Conn1', 'Table2_Conn1';
SET vTablesConnection2 = 'Table1_Conn2', 'Table2_Conn2';

for numberOfConnection=1 to 2
for each table in $(vTablesConnection$(numberOfConnection))
...
Next