Connections
Connects RLV Scribe to a SQL Server database - the destination for everything Qlik apps write back through it. A connection is a prerequisite for defining tables.
Before you start
Section titled “Before you start”- SQL Server is the only supported connection type today. The connection form has a Type shown, but it’s fixed - there’s no picker for other databases.
- The SQL login you connect with needs permission to create tables, views, and stored procedures in the target database, not just read/write existing ones - RLV Scribe builds the schema each writeback table needs automatically the first time you add one (see Tables).
- On the main screen, select Add Connection.
- Fill in:
- Display Name and Description - how this connection appears in RLV Scribe.
- Server Name - the SQL Server host. Use the same format you’d use in SQL Server
Management Studio: a hostname alone (default port 1433),
host,portfor a non-default port, orhost\instancefor a named instance. - Database Name, Username, Password - a SQL login RLV Scribe uses for every writeback operation against this database.
- Select Test before saving - RLV Scribe attempts to connect with what you’ve entered.
- Select Save. The dialog switches to a read-only summary of the connection (including the resulting connection string) - select OK to close it.
The new connection now appears in the list, ready for tables to be added to it.
When to change this
Section titled “When to change this”- Rotating the SQL login’s password - edit the connection, re-enter Password, and Test before saving; leaving it blank keeps the current one.
- The database moved to a new server - update Server Name and test again.