SQL To QVX Dynamic Action

About

The SQL To QVX Dynamic Action provides a seamless method for exporting SQL datasets into QVX (QlikView Data) files. This action retrieves data dynamically from a SQL query or database table and converts it into the QVX format, which is optimized for high-performance data loading in QlikView and Qlik Sense applications.

This functionality reduces the need for intermediate steps, improves efficiency, and ensures the data is readily accessible for analysis, enhancing productivity in data-driven decision-making processes.

Metadata tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
2. This option is typically used for debugging and is not recommended in a production environment.
3. It can be globally disabled through the options dialog .

Parameters tab

• The “Replace Variables” parameter is used to substitute variables within SQL statements.
• When the “UseEmbeddedSQL” is set to True EmbeddedSQL is used, otherwise SQL Script/Lookup is used.

Selecting Script

Editing Script

Selecting Connection

Variables tab

The Variables tab defines the variables to be updated during the action’s execution.

Execution log tab

The Execution log tab is populated after the action is executed. Double click on the row to view the log.

Related Actions

1. SQL To Text Dynamic Action
2. SQL To XML Dynamic Action
3. SQL To Insert Dynamic Action
4. SQL To Excel Dynamic Action
5. SQL To QVD Dynamic Action
6. SQL To QVX Dynamic Action

Useful Links

• Debugging Actions
• Working With Variables

Video Tutorial