topic Loading data in QlikView

Loading data

Thu, 17 Sep 2015 11:32:56 GMT

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 — Thu, 17 Sep 2015 11:35:27 GMT

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 — Thu, 17 Sep 2015 11:36:37 GMT

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 ......