Q-Eye portable is released

It is a freeware lightweight QlikView files viewer.


"It supports both QVD and QVX Files"

Portable version is designed to work with PortableApps Menu which can be downloaded from here

Portable software is a class of software that is suitable for use on portable drives such as a USB (thumb) drive or iPod or Palm PDA with "drive mode", although any external hard drive could theoretically be used.  The concept of carrying one's favoured applications, utilities, and files on a portable drive for use on any computer is one which has evolved considerably in recent years.

Download Now

VImpX version 5

New version of VImpX is available for download.

Changes Are:

  • New datasources QVD and QVX files, Windows Event Log, RSS, Google Spreadsheets, SalesForce and BrightPearl (That makes it 27 datasources in total)
  • Minor bug fixes and tweaks
  • Documentation Update

About VimpX

VImpX is universal dataimport Activex. 

By integrating one of DB Software Laboratory ETL ActiveX into your own application you can quickly introduce fully functional universal import routine and cut the time and the cost required for the development of your own.

Q-Eye View QVD and QVX files

Introducing new freeware utility:

Q-Eye: QlikView Data file viewer

  • Works with QVD and QVX files
  • Partial load by default
  • Export to Excel
  • Support for multiple documents
  • Filtering, sorting and search
  • Printing
  • Copy and paste support
  • Operating system integration

QVD Files Viewer

Download Q-Eye now 

Loading QVD files into the database

Great news: both Visual Importer ETL and Advanced ETL Processor can now load data from QVD files into various databases.
Such as: Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite and more...

Load Data from QVD Files

Note:

We did a lot of testing but there is chance that we missed something, so if you find any problems please post your comments on our support forum and we will do our best to help you.

About QVD Files

A QVD file holds exactly one data table and consists of three parts:

A well-formed XML header (in UTF-8 char set) describing the fields in the table, the layout of the subsequent information and some other meta-data.
Symbol tables in a byte stuffed format.
Actual table data in a bit-stuffed format.

A QVD contains the physical representation of an in-memory Qlikview Table.
This “RAM image” format is what allows an optimized QVD load to be so quick. The physical blocks of disk are read directly into RAM, “ready to go”.

 

QlikView - Getting single version of truth

QlikView can load the data from almost anything but in some cases it will show the users incorrect data.

Generating single version of truth

There are two problems with the picture above:

  • Same data is extracted twice
  • Since system is live, uses may get different results

QVD vs QVX

Comparison of data loading strategy into QliKView

Using QVD files

Working With QVD files

There some advantages and disadvantages of using QVD files

  • Same data for all users
  • Loader QVS pulls data into memory and saves it into the file
  • Additional processing on the QlikView server
  • QVD’s can be generated only by QlikView

Using QVX files

Working With QVX files

Benefits of using QVX files

  • Same data for all users
  • Advanced ETL Processor data saves the data into the file without loading everything into the memory
  • AETL can perform data transformation and validation on the fly
  • Can automate file transfers via FTP/Emails/HTTP/File operations.
  • Can work in distributed environment

QlikView - Integration performance boost

Great News: our QlikView connector can generate 20 million records in 11 minutes. that 7+ times more than previous version

QlikView - Data Integration performance boost

More about ETL-Tools QlikView connector

More Articles...