SQL data exports

Writes a Qlik object’s data straight into a database table every time the report runs, instead of (or alongside) emailing it.

Prerequisite

SQL exports need at least one data destination configured first, by an administrator, under Settings → Data destinations. If none exist yet, the tab tells you so.

Steps

1. Open the SQL export tab in the data-scope rail.
2. Select Add SQL export.
3. Choose the Qlik object whose data should be exported, and the data destination (database connection) to write it to.
4. Set the destination table name and how rows should be written - typically appended on each run, so the table accumulates a history over time.

Worked example

A planning team wants their daily sales figures to land in a reporting database automatically, without anyone opening Excel. An administrator first adds the database under Settings → Data destinations, then the report’s author adds a SQL export pointing at the sales table object, targeting a daily_sales table in that database. From then on, every scheduled run both emails the report and appends a fresh row of figures to the table.

Tip

SQL exports run independently of email delivery - you can disable Send by email and use a report purely to populate a database table on a schedule.