How can we connect multiple data sources in QlikView?

Question

I want to connect multiple data sources (Oracle, MySql etc) and databases. Then I want to create a table in Qlikview based on the result set of multiple select queries from the different databases.

How can we do this?

Answer 1

Hi the easiest is to create separate ODBC connections in Windows:

Then in Qlivkiew script before SELECT we have to specify which connection we want to use:

ODBC CONNECT TO [Connection Name];