topic QV Connector in QlikView

QV Connector

Fri, 04 Sep 2015 05:21:09 GMT

I Just want to know this .

Qlikview need QV connector like ODBC , OLDEB when fetching data from either SQL or MY SQL Data Base .

I want to know why don't Qlikview required any kind of connector when using the EXCEL Sheets as data source ?

Can any one help me in understanding this ?

Re: QV Connector

Peter_Cammaert — Fri, 04 Sep 2015 06:55:35 GMT

QlikView uses a generic external (QVX-based stream-)interface to connect to databases of all kinds. You can compare this to a plug-in system (extensible, also available for third-party connectors i;e. you can build your own ) They are upgradeable without needing a new server/desktop version. Also (not the least important), you can charge money for the more complex ones....

The file interfaces (which is what the Excel-XML-CSV-etc. code really is) are built-in as they are standard, well defined and don't really need upgrades. The major drawback of the latter is that you cannot add file interfaces. The major advantage of the latter is performance.

If you want, you can program a connector for reading Excel files.

Peter

Re: QV Connector

Fri, 04 Sep 2015 08:35:35 GMT

Thanks Peter FOr detail information

Regards

Kane