Qlikview

Datasource Connectors

The extension of an qlikview application is qvw. We can load data into the qlikview application(.qvw) in many ways using the script editor. Let us discuss few of them:

1. OLEDB Connection: 

By connecting to database and selecting the columns list from tables.

2. ODBC Connection: 

Creating an database connection in local machine and accessing it in the qlikview applications.

3. Load data from files: 

We can load data from files such as Excel, CSV, TXT, XML, or even HTML. While loading the data we can select the columns we needed.

4. Qlikview Applications:

This comes into use when we follow 3-tier architecture where same data is used in more than one application.

5. Web files:

When we want to load data from a web file, we can provide the url and load the data.

6.Load data from Qvd:

This comes into use when we follow 3-tier architecture where data is loaded into qvd files from database in another qlikview application.

Comments are closed.

Design a site like this with WordPress.com
Get started