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