Overview Overview EVL Data Anonymization EVL Data Anonymization EVL Validation EVL Validation EVL Data Generation EVL Data Generation QVD Utils QVD Utils EVL Manager
Omlouváme se, tato stránka ještě není dostupná v českém jazyce.

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
  • In join with other EVL Microservice(s) (like EVL Staging) can be used for example in QVD-based architecture:

QVD Utils

60 day trial version.
Download

Whitepaper

Function guide and examples.
View .pdf

Documentation

Full QVD Utils documentation.
Download View Docs

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:

IDNameCodePriceCreated
1item_111115,852016-05-04
2item_121221,252019-11-11
3item_131312,992019-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.





Questions? Contact Us

Contact Us

Email
Message