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

ETL Version Control why you need it

We do a lot of consutancy work and we decided to introduce version control after one of our customers modified transformations beyond use. Version control helped us to restore project to it's original state. Another situation when version control is very usefull is a large project with multiple developers.

Advanced ETL Processor version control tab

More about ETL-Tools

Latest ETL Software changes

+ New Version control tab was introduced
+ Version control can submit several objects now
+ Version control dialogue can delete multiple objects now
- Various bug fixes

More Articles...