Skip to content
Relevance Docs

Tables

Defines a writeback table - the thing a Qlik app’s RLV Scribe object actually reads from and writes to. Every table belongs to a connection.

Steps

Section titled “Steps”
  1. On the main screen, select the table icon on the connection you want to add a table to. This opens Manage Tables, listing every table already defined on that connection - with its ID, Display Name, and Table Name.
  2. Select Add Table.
  3. Fill in:
    • Display Name - how this table appears in RLV Scribe.
    • Table Name - the physical table RLV Scribe creates in your database. Letters, numbers, and underscores only, and can’t be changed after creation - choose it carefully.
  4. Select Save. RLV Scribe creates the underlying SQL Server schema for you - the table itself, a history table for auditing, and the views and stored procedures writeback needs - there’s nothing to create by hand in the database first.

Connecting a table to a Qlik app

Section titled “Connecting a table to a Qlik app”

The ID column in Manage Tables is the Table Id you enter in the RLV Scribe object’s property panel in Qlik Sense - see Adding the extension to a Qlik app.

When to change this

Section titled “When to change this”
  • A Qlik app needs a new writeback surface - add a table, then set its ID as the Table Id on the RLV Scribe object in that app.
  • Retiring a table - delete it here (see below) once no Qlik app references its Table Id anymore.

What can go wrong

Section titled “What can go wrong”