On-Prem SQL Server Writeback Option - Using Qlik Automation

[srivastalans]

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:

1. Enabled TCP/IP: Set the value to 1 for TCP/IP under IPALL and all other IP entries in the Windows Registry (regedit).

2. Opened Port 1433: Enabled inbound traffic on port 1433 and added Qlik’s IP addresses to the outbound firewall rules.

3. 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.

4. 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