This tutorial shows how to generate Qlik QVX files in Advanced ETL Processor. Use the QVX Writer when a workflow needs to create QlikView data exchange files without running Qlik on the processing machine.
What You Will Learn
- Configure the QVX Writer as the transformation target.
- Create a QVX file containing table metadata and data.
- Format date fields before writing QVX output.
- Prepare QVX files for QlikView or Qlik Sense workflows.
Before You Start
Open the sample workflow or prepare a small test file before applying the pattern to production data. It is easier to fix a test file than a Monday morning reporting run.
QVX Writer Docs
This tutorial uses the QVX Writer to create QlikView data exchange files from transformation output. QVX contains table metadata and the actual data, which makes it useful when Qlik needs structured input rather than another improvised export file. Improvised exports age badly.
The QVX Writer documentation explains what QVX is and how it differs from QVD. QVD is proprietary and optimised for minimum transformations inside QlikView. QVX is public and intended for high-performance data input from other systems.
Review the QVX Writer properties before scheduling the workflow. If the output includes date fields, use the standard Date Format transformation function as noted in the QVX Writer docs.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.