Loading data

[#1]

Hello Community,

Can we get various data from various dbs into a qvw file?

for example I hava a scenario,

I need to get the product data from mdb,

and customer data from sql server,

and sales data from teradata,

and categories data from DB2

and etc.

So far I loaded the data into a qvw application from log files(xml,xls) and a database(sql server).

So is it possible to load the various data from various databases into a qvw application?

Plz help out me in this.

[datanibbler]

Hi babi qlik,

well, you can. Everything QlikView can read becomes a table - you can combine data from as many (different) sources as you like.

HTH

Best regards,

DataNibbler

[maxgro · Accepted solution]

yes you can connect to many databases in the same qlik doc (also mix database, files, ftp, web, ....)

pseudo code

ODBC CONNECT TO  oracle

// this is from oracle

sql select......

// this oracle, no need to reconnect

sql select ......

ODBC CONNECT TO  sqlserver

// this is from sql

sql select......

// this sql, no need to reconnect

sql select ......