QVD vs QVX

Comparison of data loading strategy into QliKView

Using 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

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

Choosing right ETL tool

We have two ETL products Visual Importer ETL and Advanced ETL Processor.

Which one to choose depends on the complexity of the data and now you want to work with it

This article provide some examples of complex data

If you just want to load data from table, delimited file or simple XML file choose Visual Importer ETL.

If you work with complex data and require data validation, transformation or sorting and on top of it you also want to be able to generate the data select Advanced ETL Processor.

Both Advanced ETL Processor and Visual Importer ETL have 3 editions:

Standard, Professional and Enterprise:

Standard Edition is designed for desktop user who just wants to run data load or transformation manually.

Professional Edition is designed for user who wants to execute business automation processes manually.

Enterprise Edition is designed for user who wants complete automation of business processes.