Setting up a connection

Before you start saving data in your Qommentary Writeback extension, you will need to create or select an existing data connection.

Qommentary Writeback supports a range of file and database connections:

• XML

• JSON

• PostgreSQL

• MySQL

• SQL Server

• Oracle

Creating file connections

File connections are the easiest and fastest way to get started writing data in your Qlik Sense applications. It requires no database setup and data is saved in a file format.

To create a new file connection, please follow these steps:

1. Edit your sheet 2. Expand the Data connections » Data Source section

3. Click on Create a connection 4. Select a file connection (i.e. XML, JSON)

5. Fill out required details

6. Optionally, you may click on Test connection to verify that the folder connection path is valid

7. Click on Create button

If the Folder connection path is valid, the connection will be successfully created and applied to your current extension.

Other file connections supported:

• JSON

File connection properties

Property name	Description	Default
File name	Name of your file (exc. extension name)
Key column name	Name of the primary key column
Enable audit logs	Enable to track and audit changes in your table	false

Creating database connections

To create a new database connection, please follow these steps:

1. Edit your sheet 2. Expand the Data connections » Data Source section

3. Click on Create a connection 4. Select a database connection (i.e. PostgreSQL, MS SQL Server, etc)

5. Fill out required details

6. Optionally, you may click on Test connection to verify that the database connection is valid 7. Click on Create button

If the database details are valid, the connection will be successfully created and applied to your current extension.

Other database connections supported:

• PostgreSQL

• MySQL

• Oracle

Selecting an existing connection

When you add a Qommentary Writeback extension to your application, you can choose to create a new connection or select from an existing one.

To select from an existing connection, please follow these steps:

1. Edit your sheet 2. Expand the Data connections » Data Source section

3. Click on Select existing connection button 4. Pick a connection from the list

5. Click on Select button

The selected connection is successfully applied to your current extension:

Removing a connection

If you wish to disassociate a currently selected connection from your extension, you may remove it following these steps:

1. Edit your sheet 2. Expand the Data connections » Data Source section

3. Click on the "x" button

The connection is removed successfully.

You'll need to select a data connection before data can be saved.

Editing a connection

To edit a data connection, please follow these steps:

1. Edit your sheet 2. Expand the Data connections » Data Source section

3. Click on the pencil icon

4. Update details accordingly 5. Click on Save button

The connection is updated successfully.

Deleting a connection

To delete a data connection, please follow these steps:

1. Edit your sheet 2. Expand the Data connections » Data Source section

3. Click on the trash icon

4. Once a confirmation message is displayed, click on Confirm button

The connection is deleted successfully.

This operation will permanently delete the connection from the system.

Any other instances of Qommentary Writeback currently using this connection will not be able to save data until a new connection is selected.