QVD Utils

EVL QVD Utils enables reading and writing to QVD files without using Qlik Sense or QlikView. Useful for converting various sources immediately to/from a QVD file, and to prevent overloading a Qlik server by processing many, or large, QVD files.

EVL Microservices are built on top of the core EVL software and retain its flexibility, robustness, high productivity, and ability to read data from various sources; including JSON files, databases–Oracle, Teradata, PostgreSQL, etc–and Hadoop streaming data like Kafka.

High read/write performance
Ideal for automation and batch processing
Save Qlik resources by offloading processes
Improve data load times by integrating load processes into standard ETL
Can be used with other EVL Microservices, or integrated into pre-existing solutions

Example Integration with a QVD based architecture

EVL QVD Utils

6 week trial version.

Download

Whitepaper

Function guide and examples.

View .pdf

Documentation

Full QVD Utils documentation.

Download View Docs

Convert .qvd files online

Convert between .qvd and .csv files with our online utility

Go to qvdconvert.com

Pricing

Convert to/from .csv

qvd2csv
(read column subset)

Convert to/from .evd

qvd-header

Email Support

Phone Support

Guaranteed Service Level

Multiple Installations

^*When billed annually

Standard

€59/month

€49/month

€588/annually

Month

Year

Single Installation

Buy Buy Download Trial

Premium

€119/month

€99/month

€1188/annually

Month

Year

Single Installation

Buy Buy

Enterprise

Custom Pricing

Multiple Installations

Contact Sales

Command Line Utilities

qvd-header – Retrieve information from QVD header: number of records, field names as JSON, etc.

csv2qvd – Convert CSV to QVD.

qvd2csv – Convert QVD to CSV.

CSV to QVD Conversion Example

Example input CSV file with header, and semicolon separated fields:

ID	Name	Code	Price	Created
1	item_11	11	15,85	2016-05-04
2	item_12	12	21,25	2019-11-11
3	item_13	13	12,99	2019-10-05

Run:

csv2qvd table.csv > table.qvd

csv2qvd will use the field names present in the header, and data types derived from the values, to produce an output file named table.qvd.

There are several options to change the default behaviour. You can specify your field names when there is no header in the CSV for example:

csv2qvd --no-header --header="ID,Name,Code,Price,Created" table.csv > table.qvd

QVD to CSV Conversion Example

A CSV file can be created from a QVD file, with the above mentioned structure, by running:

qvd2csv table.qvd > table.csv

qvd2csv will use the field names present in the QVD header to create an output file named table.csv with header, and colon separators.

There are several options to change the default behaviour. Specify different field separators, add Windows end-of-lines, and specify format for dates:

qvd2csv --dos-eol --separator=";" --date="%d/%m/%Y" table.qvd > table.csv

Get metadata from QVD

Get number of records:

qvd-header --no-of-records table.qvd

Get the list of fields with their data types in JSON format:

qvd-header --output=json --fields table.qvd

Estimated data types can be manually changed via declarations in the EVD file (EVL data definition file). See the whitepaper or documentation for details.