1

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?

Gnik
  • 7,120
  • 20
  • 79
  • 129

2 Answers2

1

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

enter image description here

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

ODBC CONNECT TO [Connection Name];
Hubert Dudek
  • 1,666
  • 1
  • 13
  • 21
0

If you create the results tables to have exactly the same column names then Qlik will automatically concatenate those tables.

So 

ODBC [ORACLE];

SALES:
Select TransNum as OrderId,
       Amount
from xxxxxx;

odbc [other SQL];

Select OrderId,
   Value as Amount
from yyyyy;

load OrderId,
   Amount
from zzzzz.xls;

Will result in one table called SALES with the 2 columns OrderId and Amount

The Budac
  • 1,571
  • 1
  • 8
  • 10