Setting up a connection
Last updated
Last updated
Before you start saving data in your Qommentary Form extension, you will need to create or select an existing data connection.
Qommentary Form supports a range of file and database connections:
XML
JSON
PostgreSQL
MySQL
SQL Server
Oracle
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
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
To create a new database connection, please follow these steps:
1. Edit your sheet 2. Expand the Data connections 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
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:
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.
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.
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 Form currently using this connection will not be able to save data until a new connection is selected.
