Writeback SQL to MS SQL database via data gateway

[rlesage]

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

[Tony7 · Accepted solution]

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/Ho...

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

All the best, 

Tony

[NS_Qlikupdates]

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