Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please how can i connect multiple databases sql to analyze it as a single database in qlikView ?
You can create multiple connection strings and import data in qlikview.
After that, you can create single model as per your requirement.
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
Follow this pattern:
The data from all the sources will be loaded into a single QVW file for analysis.
But databases do not have the same tables
You can create multiple connection strings and import data in qlikview.
After that, you can create single model as per your requirement.
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
Follow this pattern:
The data from all the sources will be loaded into a single QVW file for analysis.
But databases do not have the same tables