topic Re: Writeback SQL to MS SQL database via data gateway in Connectivity & Data Prep

Writeback SQL to MS SQL database via data gateway

rlesage — Tue, 20 Jun 2023 11:02:25 GMT

Hi,

We would like insert data from Qlik Sense app into the MS SQL Database.

We can unfortunately not use Qlik Application Automation to insert/update these records in the MS SQL database as the database is behind the firewall. Can we use Qlik scripting (SQL Insert) to insert these lines into our MS SQL database via the data gateway direct access?

KR
R

Re: Writeback SQL to MS SQL database via data gateway

Tony7 — Tue, 20 Jun 2023 14:23:34 GMT

Hi @rlesage

That should be possible, important thing to think about is to pay attention to the difference in syntax when in Qlik Cloud when executing queries containing for example UPDATE or INSERT as outlined here: https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/How-to-load-without-SELECT.htm

Hope this gave you some clarity, otherwise you are always welcome back!

All the best,

Tony

Re: Writeback SQL to MS SQL database via data gateway

NS_Qlikupdates — Sat, 18 Apr 2026 13:40:34 GMT

Hi,

You can consider using a writeback solution like SenseOps Writeback for this use case. It allows you to send data from your Qlik Sense app to an MS SQL database, supporting insert and update operations even if the database is behind a firewall.

You can explore more here:

Product page

YouTube demo

Try it for free