Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;