Skip to content

Writeback table

Setting Up Writeback

Follow these four steps to configure Writeback:

Destination:

  • Choose between file-based or database destinations.

  • For file-based, specify the folder path, file name, and file type (e.g., CSV, QVD, Text).

  • For database, select from supported databases like Oracle, Postgres, MySQL, MariaDB, SQLite, and SQL Server. Specify the table name for the destination.

Columns:

In the Writeback extension, the "Columns" section allows users to define the data structure for the writeback operation. This section offers flexibility in selecting columns from the existing data model or defining custom input columns according to specific data requirements.

Existing Data Model Columns:

  • Users can select columns directly from the existing data model within Qlik Sense, typically dimensions or measures already present in the app's data model.

Custom Input Columns:

  • Alternatively, users have the option to define custom input columns based on their data input needs. These custom columns enable users to specify additional data fields or parameters relevant to their writeback operation. Data types for custom input columns can include dropdown selections, checkboxes, review ratings, and other value types as needed.

Define Storage:

  • Specify columns to be added in the destination. Optionally, add additional destinations and assign columns to each destination.

Trigger:

  • Configure triggers for actions upon success or failure.

  • Trigger types include SMTP for email notifications, SFTP for file movement or replication, and Qlik Actions for app refreshes.