Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
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
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