topic Re: Store a table on a SQL Server in Integration, Extension & APIs

Store a table on a SQL Server

paologobbi2 — Fri, 28 Mar 2025 15:50:42 GMT

From Qlik Sense SAAS I read data from sql server but at the end of processing I would like to return a table to sql server.
Is there a function or automation I can use?
Thank you.

Re: Store a table on a SQL Server

Frank_S — Fri, 28 Mar 2025 21:15:20 GMT

Check out these help pages.

Kind regards...

Re: Store a table on a SQL Server

marksouzacosta — Sat, 29 Mar 2025 22:51:53 GMT

Hi @paologobbi2,

I think you mean that you would like to insert data on a SQL Server Database?
If so, you have to set in your SQL Server Qlik Cloud Data Connection Allow non-SELECT queries to True - this will allow you to write INSERT SQL Statements in the Load Script.

However, Qlik was not designed to insert records in a database. You will have to do the insert statement to run row by row and this may take forever. I do not recommend this process unless you are talking about a few records.

I never implemented such solution, but I would try something like this:
1. In your Qlik Load Script, save your table as a CSV file in a Cloud Storage such AWS S3
2. Go to Qlik Data Integration and create a new Replicate Project or a Pipeline, using as source the AWS S3 CSV file and as Target your SQL Server. This should handle it.

You could also look for another native SQL Server way to load cloud files into it and figure out a way to synchronize everything (you can play with Qlik APIs, Qlik Automations, Stored Procedures).

Regards,

Mark Costa