Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
laxmanqlik
Creator II
Creator II

can we connect to two different databases with qlik sense, if yes please suggest me the way.

i have a requirement of connecting two different databases which contain co relative data in them and have to make the qlik app by fetching the data from those.

1 Reply
Gysbert_Wassenaar

Yes, no problem. Use the CONNECT and DISCONNECT commands to connect and disconnect from the databases. And load the data in between the connect and disconnect.

LIB CONNECT TO 'MyFirstDataConnection';


Table1:

SQL SELECT Foo, Bar FROM MyTable;


DISCONNECT;


LIB CONNECT TO 'MySecondDataConnection';


Table2:

SQL SELECT Foo, Baz FROM MyOtherTable;



talk is cheap, supply exceeds demand