topic Working in Multiple Database in QlikView

Working in Multiple Database

Wed, 24 Mar 2010 07:11:00 GMT

Hi,

I am new to Qlikview.

Can anyone give me an Idea about How to access multiple database in a asingle qvw file.

Working in Multiple Database

Wed, 24 Mar 2010 09:32:12 GMT

Depends how many databases you need to access and the types of databases.

Generally you would want to create a repository which would provide you with one database containing all the tables you need for your reports. Probably a datawarehouse of some sort.

If that is not possible, then I believe you can load the tables you need from each database via odbc into qlikview

Working in Multiple Database

Mon, 19 Apr 2010 13:18:00 GMT

Thanks for Replying,

I need to access 3 different database like Teradata,oracle & sql server in a single qvw file. and If I am creating a reprository, where the data will get stored and can u plz tell me the process for creating reprository.

Thanks,

Palaneee

Working in Multiple Database

Mon, 19 Apr 2010 13:25:30 GMT

Hi Palaneee,

You can use multiple database using different connectors(Like ODBC or OLEDB) and Qlikview will work on AQL and it has in built of ETL, so whatever the data you pulled from datasources it will get store in QVW application.

Regards,

Ravi...