Work with: Text, XML, Excel, Access, DBF, Foxpro, Paradox, ODBC, BDE, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView.

Working with QVX files

Those people who work with QlikView know that it requires direct connection to the database to pull the data from, which is not possible to implement in some situations. One of the solutions is to use QVD files but again there is no way to create them without using QlikView.

In version 10 QlikView has introduced support for QVX files.

QVX (QlikView data eXchange) is a new file/stream format for high performance data input into QlikView. A QVX formatted file contains metadata describing a table of data and the actual data. In contrast to the QVD format, which is proprietary and optimized for minimum transformations inside QlikView, the QVX format is public and requires a few transformations when exporting data from traditional data base formats.

Adavanced ETL processor and Visual Importer ETL allow the user to export entire data warehouse into QVX files just with in few click and no programming

Data can be generated from virtually any data source.

Note

All data is exported as UTF8 text using row delimiter

Here is the link to file format specification.

http://community.qlikview.com/servlet/JiveServlet/previewBody/2677-102-1-2852/QlikView%20QVX%20File%20Format.pdf

Online tutorial.

How to save entire datawarehouse into QVX files with just s few cliks