On-Prem SQL Server Writeback Option - Using Qlik Automation

srivastalans — Thu, 11 Sep 2025 09:53:11 GMT

Hi All,

Is there a way to write back data to an on-prem SQL Server using Qlik Application Automation from a Qlik Cloud application?

I've already installed the Data Gateway and successfully connected to the SQL Server. I'm able to retrieve data into Qlik Cloud without any issues. However, when I tried using Qlik Automation to write data back to the SQL Server, the process failed with a "Login timeout expired" error.

Steps I followed to enable write access to the SQL Server:

Enabled TCP/IP: Set the value to 1 for TCP/IP under IPALL and all other IP entries in the Windows Registry (regedit).
Opened Port 1433: Enabled inbound traffic on port 1433 and added Qlik’s IP addresses to the outbound firewall rules.
Tested Port Connectivity: Verified connectivity to port 1433 using PowerShell:
Test-NetConnection -ComputerName "your_sql_server_hostname_or_ip" -Port 1433
The connection test was successful.
Authentication Mode: Enabled both SQL Server and Windows Authentication Mode under server authentication settings in SQL Server Management Studio (SSMS).

I understand that the Qlik Data Gateway is primarily designed for read-only access to on-prem data sources. Given this, I’d like to know if there is any supported method or recommended workaround for performing write-back operations from Qlik Cloud to an on-prem SQL Server.

Thanks,

Srivastalan.S

Re: On-Prem SQL Server Writeback Option - Using Qlik Automation

NS_Qlikupdates — Wed, 19 Nov 2025 14:29:48 GMT

Recommend you to try SenseOps Writeback extension. It has its own secure writeback service that can connect directly to your on-prem SQL Server. This allows you to update or add data from Qlik Sense, without relying on Qlik Automations or exposing your database to the cloud. Know more>>

topic Re: On-Prem SQL Server Writeback Option - Using Qlik Automation in Qlik Automate

On-Prem SQL Server Writeback Option - Using Qlik Automation

Re: On-Prem SQL Server Writeback Option - Using Qlik Automation