System Architecture
The following topic outlines the system architecture for Write!.
System Architecture with an HTTP/HTTPS Interface
Write! system architecture is displayed in Figure 1 in the context of Qlik Sense Cloud Environment. The on-premise architecture that uses Qlik Sense Enterprise is similar.
The figure shows the individual communication channels to indicate a typical sequence of communications during a writeback operation.
Figure 1: Write! system architecture
Figure 1 presents the following communication flow:
1) A Qlik and Write! user opens a Qlik app containing Write! extensions in the browser. Qlik Cloud serves the app and its connected associated data.
2) The user has edited data inside Write! extensions and pressed the Save button. The software sends the edited data to the Writeback service of the Write! server.
3) The Writeback service saves the changed data in the configured databse.
4) Writeback requests a reload of the Qlik app if it has been configured to do so in the endpoint configuration.
5) Write! Management Console is available in the browser through its own port (by default 4001). HTTP is available if SSL certificates have been configured. For more information, see Network Settings.
6) As soon as the data has been successfully saved and if configured in the endpoint, the Writeback service sends a reload-trigger per HTTPS and WSS to Qlik Sense. In this way, the respective app, in which data has just been edited, is reloaded and, subsequently, this new data is made available in this respective app to all users.
7) Qlik reloads data from the updated database to which Write! saved the changes.
System Architecture with a Server Side Extension Interface
With the Server Side Extension (SSE) activated, the architecture slightly changes.
The communication flow that differs in the following way compared to the architecture without SSE enabled:
- HTTP requests between the Client and Writeback become SSE requests.
- The reload request from Writeback to Qlik becomes an SSE request.
System Architecture for Qlik Sense Cloud
Qlik Sense Cloud doesn't support HTTP and SSE connections. Therefore, an HTTPS connection is necessary including a trusted certificate for the Write! Management Console. insightsoftware also recommends a database that is accessible from Write! Server and Qlik Sense Cloud, such as MSSQL, Oracle, PostgreSQL and Azure SQL Database.